I have a problem, A comboBox linked to a list, when user picks A1 the data in cell B1 and C1 appears in text boxes on the form and
if the user picks A2 the data in cell B2 and C2 and so on.
The data that appears is not amendable.
I have a problem, A comboBox linked to a list, when user picks A1 the data in cell B1 and C1 appears in text boxes on the form and
if the user picks A2 the data in cell B2 and C2 and so on.
The data that appears is not amendable.
Last edited by Wales MB; 12-14-2012 at 05:51 AM.
the sample file you provided contains a 3x3 "table" of random words. did you upload the correct file?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes....
If someone picks apple the word green goes in one text box and hard goes in the bottom.
I have just started the form the combo box works but that's all really
ok, 2 options then...
1. =IF(A2="Apple","green","")
repeat this but change the text
or, prefered...
2. create a table with all options in it. i basicaly copied your table to D2:F4
then use vlookup to find what you need...
=VLOOKUP(A2,$D$2:$F$4,2,FALSE)
change the ,2, for the next column
Sorry think i have confused everyone..... sorry....
I have attached a new example....
If you open and press the button show form...
The combobox lets the user select one from the list generated from column A on sheet 1...
then after selecting (Say Apple) the corresponding data from column b replaces the text in box 1 (Green) on the form.....
and the corresponding data from column C replaces text in box 2 (Hard) on the form.....
Hope you can help.....
im not too familiar with comboboxes. why dont you just use a drop-down and then use the function i suggested above?
Because I need it to work from a VBA form....
The end use will be incorporated on an existing VBA form.
Thanks for your help so far.
Does anyone else have any thoughts or ideas?
Bump please
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks