Combo boxes on Userforms

R

robertguy

Hi,

can anyone please advise me on how I can link two Combo boxes on a use
from to select data in columns A and B i.e.

Column A Colum B
AA xxx
AC yyy
DE ccc
FF NNN
GG zzzz

In addition can you also advise when the user inputs data into the tw
input boxes (text boxes) on the userform and presses the an OK button
how do you get the data i.e. from the two combo boxes and the tw
inputs to save to another part of the spreadsheet say cells

W1, X1, Y1, Z1 and loop to the next row for the next input W2, X2, Y2
Z3 etc


And finally, can you explain what the difference is between an 'imag
combo box' and a 'combo box' on the toolbox.

Excel version 2000


any help would be greatly appreciated


Regards


Ro
 
Top