userform, 2 comboboxes and a textbox

[Maverikk]

Hi, I am struggling with a combobox on a userform. I need 2 cascading comboboxes and a textbox. Obviously the data in combobox 2 is dependent upon the choice made in combobox 1. Then the user can type anything in the textbox. But, depending on the choice made in combobox2 - the text/value in the textbox must be entered into a particular cell relevant to the choice. Almost like a linked cell that changes by the choice made in combobox2. Can anyone help with some code please? Thanks alot.

 

[Datsmart]

This thread has good code on dependant Combo Boxes on page 9.
http://www.mrexcel.com/board2/viewtopic.php?p=154#154

Erik, Norie, and Jindon have good code suggestions in this thread:
http://www.mrexcel.com/board2/viewtopic.php?t=152281

 

[Maverikk]

Thanks Datsmart - I will give them a go. Thanks for your quick reply - I have been going round in circles on google for days on end! Cheers.

 

[Maverikk]

This thread has good code on dependant Combo Boxes on page 9.
http://www.mrexcel.com/board2/viewtopic.php?p=154#154

Erik, Norie, and Jindon have good code suggestions in this thread:
http://www.mrexcel.com/board2/viewtopic.php?t=152281

I have found that the code on http://www.mrexcel.com/forum/showthread.php?t=82306 works just as I need it. However, do you know how to get a textbox to reference a particular cell depending on the option used in combobox 3? I have tried (unsuccessfully)

Sheets("sheet3").Cells(1, 1) = ComboBox3.Value

or

textbox1.visible = true
textbox1.value = sheet3!a1

etc etc. any help would be great. I only want the textbox to appear once combobox3 has been selected, and the entry in that textbox to be put into a cell. Cheers.