Combo Box

[Ivhee]

Hi All,

I have a combo box with the list fill range as per below. I need a code that If I select let's say week "9/16/2013" in the combo box and it will populate cell A1 with week "9/9/2013"

I need a code that will get the prior date of the selected date from the combo box.

Week
9/2/2013
9/9/2013
9/16/2013
9/23/2013
9/30/2013
10/7/2013

Your feedback is highly appreciated.


Thanks much!

[berlan]

Hi Ivhee,

here's one way:

Please Login or Register  to view this content.

[FDibbins]

@ Imran310, what was the purpose of that post? Im sure that the OP knows what a combo box is used for, else they would noy have asked the question?

[Ivhee]

Hi Berlan,

Thanks. Have tried the code but didn't work

[berlan]

Ivhee, have you change the name ComboBox1 to the specific name of your combo box. Also, did you put the code within the worksheet module it is used in?

[berlan]

By the way, did you use an ActiveX control? Sorry for not checking that earlier.

[Ivhee]

Hi Berlan,

Have tried it again with some changes and it worked!! Thanks a lot for your help.

[berlan]

Please find attached a combo box workbook example, which should do what you asked for. I hope it can be of help

[berlan]

Ivhee, I did not see your post before I posted the workbook example.

Glad it worked out

[Ivhee]

Hi Berlan,

Thanks very much for your help.