Posted to microsoft.public.excel.programming

scrabtree[_2_] scrabtree[_2_] is offline

external usenet poster

Posts: 47

combobox

It is a combobox from the controls toolbar. Below is the
change event code I have wrote. The program keeps
stopping, thought, and highlighting: "cmbcc.RowSource =
Sheets("Coding").Range("B4:B12")"

Private Sub cmbmajorarea_Change()
If cmbmajorarea.Value = "Environmental" Then
cmbcc.RowSource = Sheets("Coding").Range("B4:B12")
Else
cmbcc.Value = "2"
End If
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
fill combobox depending on selection from another combobox	Adam Francis	Excel Discussion (Misc queries)	2	July 24th 08 07:39 PM
combobox into another combobox	girlie	New Users to Excel	1	September 26th 06 10:31 AM
COMBOBOX	smiley	New Users to Excel	1	October 12th 05 02:01 PM
combobox	Nicky*	Excel Programming	3	July 28th 03 09:26 PM
Combobox	Scott	Excel Programming	2	July 23rd 03 02:49 PM

All times are GMT +1. The time now is 08:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us