LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 154
Default CODE FOR CHECK BOXES, AND EXCEL AS ATTACHMENT !

2 questions:
(1) I have created a check box in a worksheet using the visual basic
toolbar (not forms). I need a code to assign to the check box such that
when clicked on, the check box displays "X" instead of a check mark, and
when clicked on again it displays nothing. In other words when clicked
on, the check box should toggle between "X" and not showing anything.

(2) I need a code that will attach the current workbook (say
WorkbookA.xls) as an e-mail attachment. I use microsoft outlook. The
"TO:" field of the e-mail should contain two addresses like
" and " and the subject line of the e-mail
should contain a subject like "Hello World!". The body of the e-mail
should contain a message like "Thank you for your participation". All of
the above must be done automatically.
Any help would be greatly appreciated. Thanks in advance!
Jay Dean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
VBA code for the Check Boxes in a form HKS Excel Discussion (Misc queries) 3 June 24th 08 09:42 PM
Enable check box in protected sheet + group check boxes Dexxterr Excel Discussion (Misc queries) 4 August 2nd 06 12:00 PM
Code for many check boxes Bob Excel Programming 5 January 24th 04 03:48 AM
Code for Many check boxes Bob Excel Programming 0 January 23rd 04 02:16 AM
code to hide check boxes Matt Excel Programming 4 January 10th 04 06:31 PM


All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"