Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box - VBA form
HI
I have created a form via VBA, I have included a combo box which I want to point at a specific list of entries. I can do this on a normal worksheet using data validation, how do I do it in VBA design mode -- thanks Roy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box - VBA form
Hi,
One way Private Sub UserForm_Initialize() For x = 1 To 6 ComboBox1.AddItem Worksheets("Sheet1").Cells(x, 1).Value Next End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Roy Gudgeon" wrote: HI I have created a form via VBA, I have included a combo box which I want to point at a specific list of entries. I can do this on a normal worksheet using data validation, how do I do it in VBA design mode -- thanks Roy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box - VBA form
Maybe neater
Private Sub UserForm_Initialize() ComboBox1.RowSource = "Sheet1!" & "$A$1:$A$6" End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Roy Gudgeon" wrote: HI I have created a form via VBA, I have included a combo box which I want to point at a specific list of entries. I can do this on a normal worksheet using data validation, how do I do it in VBA design mode -- thanks Roy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box - VBA form
Thanks Mike
Easy when you know how, appreciate prompt reply and solution. Sure I'll be back, am still learning and I'm not a quick learner ! -- thanks Roy "Mike H" wrote: Maybe neater Private Sub UserForm_Initialize() ComboBox1.RowSource = "Sheet1!" & "$A$1:$A$6" End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Roy Gudgeon" wrote: HI I have created a form via VBA, I have included a combo box which I want to point at a specific list of entries. I can do this on a normal worksheet using data validation, how do I do it in VBA design mode -- thanks Roy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo boxes on a form | Excel Discussion (Misc queries) | |||
VBA Form Combo Box question. | Excel Discussion (Misc queries) | |||
Using a combo box in an Excel form | Excel Discussion (Misc queries) | |||
Form Combo Box | Excel Discussion (Misc queries) |