data input format

[j18k]

Beforehand sorry if this has been answered before, but I'm going crazy with this:

On an user form I need a text box to show the numbers being input in the currency format, before the value is passed to a cell. (like the input mask in Access)

In my country prices are in millions, so I need the user to be able to see the thousands separators as data is being entered.

Thanks

 

[j18k]

no answers

Was my question too stupid, or no one knows the answer?

Any help will be appreciated

 

[Norie]

There is no input mask in Excel.

You could simulate one using the various events (Change perhaps) of the textbox.

An easier method would be to set the value's format when you place it on the worksheet.

How are you currently getting the value pntp the spreadsheet?

 

[j18k]

Th thing is I'm saving the input in a variable then latter I assign the value to a cell with .value(), so I wold like the imput field to be masked as $###,###.## so the user won't make a mistake by enetring 1000 instead of 10000

 

[Norie]

Can you post the code you are using to put the value in the worksheet?

 

[j18k]

Well it's just a regular tetxtbox named NCANT then:

Worksheets("SOURCE").Cells(LINEACOD, 24).Value = NCANT.Value()

The worksheet value is well formated, looks like $10'100.000,05.

The thing I need is for the user to see the dots and comas as he types the value in the text box, so that the above value wouldn't be misstyped as $1'010.000,05