Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have the following code to transfer an option from a combobox to a
cell on one sheet. I've used this code several times before in other workbooks, and it works absolutely fine, but, for some reason, in my current project, it just comes up as an error and the 'Range("G11").Select' line is highlighted in yellow. Is there some obvious or uderlying reason for this, does anyone know? The code is: Private Sub ComboBox1_Change() Worksheets("How").Activate Range("G11").Select ActiveCell.Value = ComboBox1.Value Worksheets("Statskeeper").Activate End Sub I've tried the same code in a commandbutton_click as well, but with the same result. Any ideas would be greatly appreciated. Thanks Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbook startup condition | Excel Discussion (Misc queries) | |||
Error message opening Excel97 workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
copy\paste from one workbook to another | Excel Discussion (Misc queries) |