Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a RowSource Depending on ComboBox Choice
Hi there
I have a userform where I select a date in the first combo box. (cmbPayDate) Then, depending on whatever that choice is, I would like the next combo box to be a selection of 7 dates for that pay week. (cmbDateWorked) Can someone advise how I can do that?? Thank you in advance! Mike L (NZ) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a RowSource Depending on ComboBox Choice
hi
not sure what you are asking for specificly but in therory a cascadeing combo works something like this...... Private Sub ComboBox1_Change() If ComboBox1.Value = "HPQEI" Then ComboBox2.rowsource = "a16:a22" Else If ComboBox1.Value = "HPQBV" Then ComboBox2.rowsource = "F1:F14" End If End If End Sub set the rowsource for combobox2 from combobox1 based on the value you select. you may have to change the ranges. pay with it Regards FSt1 "Blobbies" wrote: Hi there I have a userform where I select a date in the first combo box. (cmbPayDate) Then, depending on whatever that choice is, I would like the next combo box to be a selection of 7 dates for that pay week. (cmbDateWorked) Can someone advise how I can do that?? Thank you in advance! Mike L (NZ) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a RowSource Depending on ComboBox Choice
hey there FSt1
thanks heaps for that!! i haven't had a play with it yet, but what you've said makes sense!! i'm sure i can get it going from that!! cheers! mike "FSt1" wrote: hi not sure what you are asking for specificly but in therory a cascadeing combo works something like this...... Private Sub ComboBox1_Change() If ComboBox1.Value = "HPQEI" Then ComboBox2.rowsource = "a16:a22" Else If ComboBox1.Value = "HPQBV" Then ComboBox2.rowsource = "F1:F14" End If End If End Sub set the rowsource for combobox2 from combobox1 based on the value you select. you may have to change the ranges. pay with it Regards FSt1 "Blobbies" wrote: Hi there I have a userform where I select a date in the first combo box. (cmbPayDate) Then, depending on whatever that choice is, I would like the next combo box to be a selection of 7 dates for that pay week. (cmbDateWorked) Can someone advise how I can do that?? Thank you in advance! Mike L (NZ) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a RowSource Depending on ComboBox Choice
hi
thanks for the feedback. and after reading my post i think i need to take a course in spelling or maybe drink 1 less beer before posting. oh well. regards FSt1 "Blobbies" wrote: hey there FSt1 thanks heaps for that!! i haven't had a play with it yet, but what you've said makes sense!! i'm sure i can get it going from that!! cheers! mike "FSt1" wrote: hi not sure what you are asking for specificly but in therory a cascadeing combo works something like this...... Private Sub ComboBox1_Change() If ComboBox1.Value = "HPQEI" Then ComboBox2.rowsource = "a16:a22" Else If ComboBox1.Value = "HPQBV" Then ComboBox2.rowsource = "F1:F14" End If End If End Sub set the rowsource for combobox2 from combobox1 based on the value you select. you may have to change the ranges. pay with it Regards FSt1 "Blobbies" wrote: Hi there I have a userform where I select a date in the first combo box. (cmbPayDate) Then, depending on whatever that choice is, I would like the next combo box to be a selection of 7 dates for that pay week. (cmbDateWorked) Can someone advise how I can do that?? Thank you in advance! Mike L (NZ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel how to take choice of 75 rows - create form of 10 selectons | Excel Worksheet Functions | |||
Create formula to choose price based on previous choice. | Excel Worksheet Functions | |||
Show pictures in excel depending of a choice! | Excel Discussion (Misc queries) | |||
help - create a multiple choice test | Excel Discussion (Misc queries) | |||
How do i create a multiple choice drop down list | Charts and Charting in Excel |