ActiveX Combo Box Next Cell

[washburnbill]

First post on this forum...
I am trying to build a kitchen recipe spreadsheet. I would like to have a add ingredient dropdown list. Datavalidation is way to small so I added an activex combo box and linked it to list of all available ingredients.
I would like to make a choice in combobox and have the selection go to cell B22, then make another choice and have selection go to B23, then B24 and so on. I will also be referencing each selection made.
Any help is much appreciated.

[mehmetcik]

Hi.

I find that Activex controls are not very easy to work with.

I use Userforms for most things.


Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[washburnbill]

Uploaded Before and After. I'll have to work on my formulas for costing. LOL just plugged some stuff in. Please let me know if didn't upload.

[mehmetcik]

Ok

I have made a start for you.

Place all three attachments into the same folder and then open the spreadsheet.

Have a play and come back to me.