Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Lost focus of UserForm

Hi,

I have a macro that sends emails. The send email feature is in a loop
so it could possibly send out multiple emails to multiple addresses.
Before the email is sent, I have a Userform that pops up and tells you
what information you are about tho send. I hit Continue (which does
"Unload Me") and the email is sent.

Let's say there are two emails that are going to go out though. The
form pops up, the email is sent, and then.....

nothing seems to happen.

As soon as I click on Excel though, the next dialog box pops up (with
the info that will be sent in the second email) and everything goes
out fine. So, I'm not sure why the focus for the second user form is
lost? I've tried a few things, but can't figure it out.

I bring up the form like this:

UserForm1.TextBox1.MultiLine = True
formbody = "To: " & contactArray(z) &
vbCrLf & "Subject: " & strsub & vbCrLf & vbCrLf & formbody
UserForm1.TextBox1.Value = formbody
UserForm1.Show

Thanks in advance for any advice/help with this.

Corey

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Lost focus of UserForm

Anyone?

Reply
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
Address of Cell that lost focus? HotRod Excel Programming 7 April 27th 05 02:39 PM
Lost Focus apply to cell John[_91_] Excel Programming 1 February 24th 05 05:00 PM
Lost Focus - Applying to cell Paul Silverman Excel Programming 2 August 29th 04 01:10 PM
Textbox focus lost Stift[_25_] Excel Programming 7 June 7th 04 09:58 AM
Cell Lost Focus Craig[_5_] Excel Programming 1 July 23rd 03 05:18 AM


All times are GMT +1. The time now is 12:34 AM.

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

About Us

"It's about Microsoft Excel"