Posted to microsoft.public.excel.programming

lynda

external usenet poster

Posts: 10

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting special format for a cell	Ruslan	Excel Worksheet Functions	6	March 15th 10 04:02 PM
Setting the date format	Boris	Excel Discussion (Misc queries)	3	November 18th 08 12:55 PM
Setting Excel cell format	Sasha	Excel Worksheet Functions	1	October 6th 08 04:29 PM
I need help in setting my paper in apa format in microsoft	loveselffirst	Excel Discussion (Misc queries)	1	October 15th 07 08:45 PM
need help setting a simple format to keep rent.	setting a format on excel	New Users to Excel	2	July 20th 06 12:03 AM

All times are GMT +1. The time now is 05:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us