Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting combobox
In a form users, enter an amount in a text box. They can
enter 2.00, 2.0 or 2 for $2.00. This data is then moved to a combobox. However the user enters the data is how it appears in the combobox. Is there a way to either (1) format the amount as 2.00 automatically, no matter how they enter it, or (2) force the user to enter the data correctly before they can leave the text box (private sub?)? Thanks for the help....Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting combobox
sStr = Textbox1.Text
sStr = replace(sStr,"$","") if isnumeric(sStr) then sStr = format(cdbl(sStr),"0.00") Combobox1.AddItem sStr End if -- Regards, Tom Ogilvy "JT" wrote in message ... In a form users, enter an amount in a text box. They can enter 2.00, 2.0 or 2 for $2.00. This data is then moved to a combobox. However the user enters the data is how it appears in the combobox. Is there a way to either (1) format the amount as 2.00 automatically, no matter how they enter it, or (2) force the user to enter the data correctly before they can leave the text box (private sub?)? Thanks for the help....Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set up conditional formatting in Combobox list? | Excel Discussion (Misc queries) | |||
formatting the list items for ComboBox created using Forms | Excel Discussion (Misc queries) | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
cell formatting based on combobox | Excel Programming | |||
Formatting a ComboBox selection | Excel Programming |