Show Data Form

[David Holtby]

(Excel 2002),
When I launch the built-in data form from the menu (Data - Form) the
calculated fields are currency/number/date formatted as they are in my
the worksheet.

If I launch the form from VBA (Active.Sheet.ShowDataForm) the
calculated cells have their default USA currency/number/date formats.

Anyone got any suggestions how to get the form to display the desired
formats in the VBA launched Form?



David

 

[Jim Rech]

See if opening the form this way helps:

CommandBars.FindControl(, 860).Execute

--
Jim Rech
Excel MVP
|
| (Excel 2002),
| When I launch the built-in data form from the menu (Data - Form) the
| calculated fields are currency/number/date formatted as they are in my
| the worksheet.
|
| If I launch the form from VBA (Active.Sheet.ShowDataForm) the
| calculated cells have their default USA currency/number/date formats.
|
| Anyone got any suggestions how to get the form to display the desired
| formats in the VBA launched Form?
|
|
|
| David
|
|
| --
| David Holtby
| ------------------------------------------------------------------------
| David Holtby's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=15404
| View this thread: http://www.excelforum.com/showthread.php?threadid=270137
|