setting format in vb

[Lynda]

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

 

[Bob Phillips]

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)

 

[Tom Ogilvy]

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