Input box query

[Chewyhairball]

Hi Guys

column A on my spreadsheet is used for inputting the date and column c is used for inputting Bin1 or Bin2 or Bin 3 on the same row.
I would like if possible for an input box to appear when a date is entered in column a and for the input box to offer 3 choices ( bin 1, bin 2, bin 3). You would select which one you want and it inputs your choice into column c.

I am not looking for a data validation list as I can do that but an input box with multiple choices.

thank you in advance

rory

 

[Chewyhairball]

Got it! Works perfect�� Shame it is yes no cancel and not something like 1,2,3. Thanks for this. ��
rory

 

[Chewyhairball]

Ok. It creates a list box in the next cell but it doesn’t let me populate it. I pasted all the code you gave me in the same sheet?

thanks

 

[Yongle]

If you change

Private Sub PopulateListbox

to

Sub PopulateListbox

{ALT}{F8} allows you to run it

 

[Chewyhairball]

Thanks everyone. Much appreciated ��