View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil[_18_] Neil[_18_] is offline
external usenet poster
 
Posts: 1
Default 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