Big Monkey
Active Member
- Joined
- Nov 5, 2005
- Messages
- 255
There are so many threads on user forms and combo boxes, I gave up after reading for over 1.5 hours and popped in a DVD.
I just started creating my first user form, and I have to say it is pretty neat stuff. So far I have only gotten as far as the layout, no code at all yet.
I have various labels, a few frames, radio option buttons, a couple of text boxes, and a couple of combo boxes.
It is looking real good to me, but now I have to make it actually do something with code. Of course I know almost nothing about VBA code, and this forum has certainly been a godsend for me.
OK, so here is my deal: I have two combo boxes at the moment. I have various defined name ranges which reference lists on a worksheet. Initially I was having trouble finding out how to input the list I needed in combo box 1. After some reading, I found I could simply input my defined name list in the RowSource property. Awesome! I was happy to progress.
However, now I want for the second combo box to populate other defined lists depending on the value of combo box 1. A couple of weeks ago, I learned that this could be done in a cell by using the INDIRECT function and referencing the validation list. I don't know if this is possible to do in code, but I sure haven't found how to go about it.
Any help guys?
P.S. Happy Thanksgiving!
I just started creating my first user form, and I have to say it is pretty neat stuff. So far I have only gotten as far as the layout, no code at all yet.
I have various labels, a few frames, radio option buttons, a couple of text boxes, and a couple of combo boxes.
It is looking real good to me, but now I have to make it actually do something with code. Of course I know almost nothing about VBA code, and this forum has certainly been a godsend for me.
OK, so here is my deal: I have two combo boxes at the moment. I have various defined name ranges which reference lists on a worksheet. Initially I was having trouble finding out how to input the list I needed in combo box 1. After some reading, I found I could simply input my defined name list in the RowSource property. Awesome! I was happy to progress.
However, now I want for the second combo box to populate other defined lists depending on the value of combo box 1. A couple of weeks ago, I learned that this could be done in a cell by using the INDIRECT function and referencing the validation list. I don't know if this is possible to do in code, but I sure haven't found how to go about it.
Any help guys?
P.S. Happy Thanksgiving!