cell updation with combobox value

[sandysharma]

Hi All,

I have seen someone at my workplace using a combo box in excel sheet that contains the names of Months. Now one cells gets updated with the number of month that is selected in the combo box. so for an example if I select March in combo box cell B1 gets the value of 3. If I select May then cell B1 values changes to 5. There is no formula reflecting when he selects B1. Any one any idea how this is done....

Thanks and Regards,
Sandeep

 

[Eloise T]

See the yellow highlighted box in cell B2. When you click on B2, it displays the tab. If you click the tab, you get the drop down window to select the month.
See the attached file. The formulas in cells C3 to J3 give the monthly sales or (whatever you wish) for Abel to Henry. See the Formulas tab on the spreadsheet for further information on the formula.
Questions?

 

[sandysharma]

Thanks Eloise,

Though this does not seem to be what I am looking for but yes this does solve one of my other queries. So thanks a ton!!

For my current query let me share a file with query.

 

[vletm]

sandysharma
copy next formula to 'somewhere'
=MATCH(LEFT(B1,3),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0)
and You'll get Your 'value'.

 

[shrivallabha]

If you want to do it without formula then you need to use Form Controls. See if attached file is what you are looking for.

Sheet 1 shows Demo. Sheet 2 shows "How To (do it)".

 

[sandysharma]

Awesome Shrivallabha....!!
This is exactly what I was trying to do. Thanks a ton once again!!

 

[sandysharma]

Thanks everyone for giving your precious time and putting efforts!! Great Learning from all of you...God Bless You All!!!