Posted to microsoft.public.excel.programming

Nick

external usenet poster

Posts: 39

Change active cell properties with command button

what code you have.

-----Original Message-----
I have a command button(cmdExempt) that when I click it,
I want it to first clear the formatting in the active
cell, then remove the data validation, then change the
font style to wingdings2, then set the font to bold, then
change the font size to 20, then type a "P" in the cell.
I cannot get it to work. Any help would be great.
Thanks. Matt
.

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
Command Button Properties	FredL	Excel Discussion (Misc queries)	2	February 14th 08 08:20 PM
Command Button Control Properties	JosiahW	Excel Discussion (Misc queries)	1	May 11th 07 08:45 PM
command button properties	gbeard	Excel Worksheet Functions	4	April 21st 05 06:02 AM
Command Button that changes cell properties	Henry[_5_]	Excel Programming	0	January 30th 04 01:21 AM
Command Button Properties	Darren O'Connell	Excel Programming	1	July 17th 03 09:34 AM

All times are GMT +1. The time now is 08:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us