How to access value returned by combo box?

[jb]

I have a combobox which have options like Sunday, Monday upto Saturday. Upon selection of option I want to display some date in one of the cell. I got formula from this website but formula specifies:

Assuming combo values are 1 for Sunday, 2 for Monday... 7 for Saturday.


=TODAY()-WEEKDAY(TODAY()-x)+7

How to refer x in formula? What should I write in place of x in this formula. Combobox is in cell a1 and formula to be placed in b1.

 

[vasim]

Assuming you are using form control.....Link your combobox to a particular cell....right click "Format control" - "Control" & "Cell Link" - reference the linked cell.


Replace X with the linked cell.

 

[jb]

I am not using form control because it displays drop down arrow symbol. I am using the sheet for printing. So I have created list using

Data menu - Data validation from Data tools - Data validation option - Settings tab - Validation criteria - Allow : List option - Source : Range of cell when options are typed.


Combo created this way will show drop down arrow symbol only when mouse moves on cell in which combo box is created.

 

[vasim]

Hmmmm......I'm sure there are better solution...but right now in my mind is to create a table as SUNday, Monday and so on with 1,2, and so on, use Vlookup to identify the selected day's number and give your X reference to this cell....