setting format in vb
 

Is it possible to set the format of a cell in vb?

I have a sheet with a calendar control and if the user
presses the calendar whilst on a cell with format of
number 2 decimal places the format changes to date making
any input to the cell invalid until the format is changed
back.

Thanks

Lynda

setting format in vb
 

Lynda,

All cells can be changed by the Numberformat property, such as

ActiveCell.NumberFormt = "dd mmm yyyy"

or you can test it

If ActiveCell.Numberformat = "0.00" Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lynda" wrote in message
...
Is it possible to set the format of a cell in vb?

I have a sheet with a calendar control and if the user
presses the calendar whilst on a cell with format of
number 2 decimal places the format changes to date making
any input to the cell invalid until the format is changed
back.

Thanks

Lynda

setting format in vb
 

Activecell.Numberformat = "#,###.00"

--
regards,
Tom Ogilvy

"Lynda" wrote in message
...
Is it possible to set the format of a cell in vb?

I have a sheet with a calendar control and if the user
presses the calendar whilst on a cell with format of
number 2 decimal places the format changes to date making
any input to the cell invalid until the format is changed
back.

Thanks

Lynda