Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting contents of a text box in vba
Dumbo question, but this is about my second day ever playing with VBA.
I have a text box (not in a user form, just a rectangle with text written in it) that contains the names/e-mails of a distribution list on a worksheet. I have a macro that will send an e-mail using the Outlook .To function at a click, but I want to use the contents of this box. I know how to use the contents of a cell, but I really need to use the text box it must be really simple, but it's eluding me. I keep searching the net but searching for 'textbox' keeps leading me to userforms which isn't what I need. Can anybody help? - - How far off am I with SendTo = ActiveSheet.Range("Rectangle 3").Value |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting contents of a text box in vba
As a demonstration from the immediate window:
? activesheet.Rectangles("Rectangle 1").Text abcdef -- Regards, Tom Ogilvy "Neil" wrote in message ... Dumbo question, but this is about my second day ever playing with VBA. I have a text box (not in a user form, just a rectangle with text written in it) that contains the names/e-mails of a distribution list on a worksheet. I have a macro that will send an e-mail using the Outlook .To function at a click, but I want to use the contents of this box. I know how to use the contents of a cell, but I really need to use the text box it must be really simple, but it's eluding me. I keep searching the net but searching for 'textbox' keeps leading me to userforms which isn't what I need. Can anybody help? - - How far off am I with SendTo = ActiveSheet.Range("Rectangle 3").Value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting certain text in long row of text | Excel Worksheet Functions | |||
Selecting a filepath based on cell contents | Excel Discussion (Misc queries) | |||
Selecting all contents on page (range) | Excel Programming | |||
Selecting & Displaying An Array's Contents | Excel Programming | |||
Selecting ranges with a text box | Excel Programming |