Combo Box Selection

[Menessis2]

Once the combo box has been clicked and the value saved to a variable is there a way to get the range that was used? In my case the "row". I have a list (range) of customer names and phone numbers and such. After selecting a customer name from the combo box I want to fill out a sheet with all that information that goes with that selection.

Thanks
Menessis

 

[6StringJazzer]

Is the combobox on a worksheet or a userform? If it is on a worksheet, is it an ActiveX or a Forms control? Do you have it linked to a cell?

Please show the code where you save the value to a variable.

 

[My Aswer Is This]

So tell us what you would like to happen after you choose the value from the combobox.

So for example if you choose 2 from the combobox.
Your script could say
Dim ans as long
ans=Combobox1.value

Sheets(2).Cells(ans,1).Value="Duck"

This is a example

 

[Menessis2]

Hi guys. Once I have the initial value, in my case it will be a "job tag" from a data list of all the job tags, company names, contacts, phone numbers and anything else associated with that job tag. Since each set of data is in a row it would be easy to use the row number and an offset to grab the associated data and fill out the work order. Other wise I will have to use a loop to do it. Not a big deal.

Thanks
Menessis

 

[My Aswer Is This]

If you need help we would need specific details of what you want.

 

[Menessis2]

I will post a few screen shots tomorrow to explain a little better.