Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the format of a cell after choosing from a combobox.
I have a sheet that requires different cell formats depending on what
information is being entered. I need to use a drop down box for the end user to endter different "Scores." Ex: if the end user is entering test scores the corisponding cells need to be percentages (89.9%), but if they are entering call lenth them the cells need to be numbers (705.25). The thing is the cell needs to switch between those format depending on the catigory chosen from the combobox. Help! David. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help choosing a chart format. | Charts and Charting in Excel | |||
Changing Cell format | Excel Discussion (Misc queries) | |||
In an excel cell,choosing a value,similar to combobox in VB - reg | New Users to Excel | |||
Cell format changing on the fly | Excel Worksheet Functions | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) |