VBA Code to Insert Drop Down List

C

chacha

Hi
Hopefully somebody can help me with this.

In my spreadsheet the user will enter a number (say 5)
Now I need to insert 5 new rows with a drop down list in column 3

For i = 1 To nMembers
startPoint.Offset(i, 0).EntireRow.Insert
startPoint.Offset(i, 0) = i
startPoint.Offset(i, 3) ' Insert Dropdown list
startPoint.Offset(i, 4) ' Insert Dropdown list
Next i

The data gathered from the user's selection from the list in column 3 will
be user to poplate the drop down list in column 4.
For example the first drop down list will show car manufacturer's (Toyota,
Mazda etc) Then the second will show Yaris, Corolla, Camry... if Toyota is
selected
Any thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
drop down list 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1

Top