LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Steve
 
Posts: n/a
Default Often-Used Code not working in a new Workbook

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook startup condition wikegolfa Excel Discussion (Misc queries) 3 December 16th 04 03:11 PM
Error message opening Excel97 workbook cobbler Excel Discussion (Misc queries) 2 December 11th 04 05:31 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 02:02 PM
how can I duplicate or copy a workbook then divide selected cells. macros excel... duplication and calculat Excel Discussion (Misc queries) 1 November 29th 04 03:16 PM
copy\paste from one workbook to another Mark Excel Discussion (Misc queries) 0 November 25th 04 10:55 PM


All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"