Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox doesn't load cell value at startup
I've got my combobox to apply the change made to it immediately with:
Private Sub ComboBox1_Change() Worksheets("sheet1").Range("C16") = Me.ComboBox1.Value End Sub ....and I leave the controlsource empty But now, when the form loads, it doesn't load the cell value back into the combobox, it's just blank... How do I adjust this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox doesn't load cell value at startup
Private Sub UserForm_Initialize()
If Worksheets("sheet1").Range("C16") < "" Then For Each c In Range(ComboBox1.RowSource) If c = Worksheets("sheet1").Range("C16") Then ComboBox1.Value = c Exit Sub End If Next c End If End Sub Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to load Excel startup files through code | Excel Programming | |||
Toolbar should not load at startup | Excel Discussion (Misc queries) | |||
Unable to load files from alternate startup folder | Excel Discussion (Misc queries) | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Load Sheet2 on Startup?? | Excel Programming |