RE: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-05 Thread Rajan_Verma
Linked Drop-Downs in a User form Hi Rob, Attached is the solution to your query. It may not be a perfect one, but tried it as it came to mind :) Regards, DILIPandey On 8/4/11, tuffhu...@yahoo.com tuffhu...@yahoo.com wrote: Hello! First post, so bear with me. I'm a novice VBA user (and love

Re: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-04 Thread Dilip Pandey
Hi Rob, Attached is the solution to your query. It may not be a perfect one, but tried it as it came to mind :) Regards, DILIPandey On 8/4/11, tuffhu...@yahoo.com tuffhu...@yahoo.com wrote: Hello! First post, so bear with me. I'm a novice VBA user (and love it!), but here is what I want to

Re: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-04 Thread tuffhu...@yahoo.com
Thanks for the time. However, it's not quite what I was looking for. I am trying to design a user form that basically interviews the user. The first question will be What manufacturer? (Instead of a list box, I think a combo box is actually better). There are at least 5 different choices

Re: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-04 Thread Dilip Pandey
I got the point, can you attach a sample file for me to apply revised logic. Regards, DILIPandey On 8/4/11, tuffhu...@yahoo.com tuffhu...@yahoo.com wrote: Thanks for the time. However, it's not quite what I was looking for. I am trying to design a user form that basically interviews the

$$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-03 Thread tuffhu...@yahoo.com
Hello! First post, so bear with me. I'm a novice VBA user (and love it!), but here is what I want to do: I want to create a data-validated list box whose options changed based on entries in an original list box. For example, the first list box would contain product manufacturers, and the second

Re: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-03 Thread Prakash Paul
Dear Robb, I have attached a simple example on drop down list box. Based on the first selection the details in the second list box get changed. Similarly in the third list box. 1. name the range 2. go data --- data validation --- select list box 3. use indirect function to call the named