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) |
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) |
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) |
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) |
All times are GMT +1. The time now is 04:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com