Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set Cells equal to a combo box without using VB in excel

Status
Not open for further replies.

Carrion

Technical User
Jul 26, 2002
27
US
Hello, I need to know how to set multiple cells equal to different columns in a singular combo box, with out using excel. Is this even possable

thanks
trace
 
trace,

If you use a Control Toolbox Combobox, then you're stuck with VB.

However, you can use a Forms Combobox and use a cell link for the selected value index.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
And how would you do that with VB? sorry i'm abit new to VBA, but all i want to do is select a value from a combo box and have that set a cell to the same value.
 
Please start a new thread - in the VBA forum (Forum707)

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top