Hello, I am trying to create a combobox in Excel that would display
multiple values such as:

Tank Top Blue Large $30.00
Tank Top Red Medium $20.00

Etc.

It could have 500 items or more in the Combobox. I would of course have
the values from a range in another sheet in that workbook.

I want the user to be able to type a "T" for example to access all of
the inventory that starts with "T" for Tank Top or "B" for Bikini etc.,
to narrow the inventory in the combobox down.

When the user selects a value such as the Blue Tank Top, as above I
want cells in Excel to be be populated, for example:

Description Color Size Price

The user could select as many as 50 different items so everytime the
user clicks in a cell underneath, I want the combobox to show (be copied
to many cells). In experimenting, I noticed that if the user clicks in a
cell, the combobox shows up and if the user selects a value then changes
their mind, they cannot delete the entry to clear the cell.

So basically it is a order sheet, but you know human nature, people
change their minds. The user must not be able to edit the cell (change a
value), but if they make a mistake and select something in the combobox
and do not want it after all, I want the cell to be empty or if the user
wants to change the item, I want the value to be able to be changed.

After the user selects all the items they want, I will have Excel
calculate the totals of all the products.

I know how to create a user form, but I do not want to user one, I just
want to use the combobox and show multiple values and have the
coordinating cells populated.

Too much to ask? I used to program in VBA and just need a refresher.

I would greatly appreciate any help that is provided.

Kind Regards,

Tina


--
tinaw
------------------------------------------------------------------------
tinaw's Profile: http://www.thecodecage.com/forumz/member.php?userid=355
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=101087