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: 175
Default Interaction between 2 UserForms

There are 2 things I need help with.

1) The user lists some PO numbers to be processed within UserForm7. I
have a MsgBox in UserForm7 that tells the user during processing that
a PO# he entered was not found. I wanted to control the fonts in the
MsgBox so that it's easier to read, but I'm finding out that you
can't change the fonts of a messagebox within the macro. I know you
can other ways, but this will be used in multiple computers. An
alternative would be a UserForm.

So, I designed one (UserForm14) with just an OK button. I want the OK
button to send control back to continue the processing that was
interrupted in UserForm7. That's how it works with the MsgBox that I
currently have in UserForm7.

What code can I put in the OK button of UserForm14 to make it continue
where it left off in UserForm7. Can you switch control back like this?

'OK button in UserForm14
Private Sub CommandButton1_Click()
'OK button

End Sub

2) I put a Textbox in UserForm14 that will show the PO# that caused
the interruption in UserForm7. I tried to put an Initialize statement
in UserForm14 to show the PO# in question. But, it's not showing up.
Here's what I have in UserForm14 for TextBox1.

Private Sub UserForm_Initialize()
PONum = TextBox1
End Sub

Here's part of UserForm7 that shows how the value of PONum is set.
Dim PONum As String

Worksheets("Official List").Activate
If Me.Controls("TextBox" & i * 2 - 1).Text < "" Then
PONum = Me.Controls("TextBox" & i * 2 - 1).Text
CountPOtoValidate = Application.CountIf(Range("J:J"), PONum)

Am I correct in thinking that PONum is the correct variable to use in
the UserForm14 Initiialize statement? Maybe a declaration statement in
UserForm14 is needed?

Any help would be appreciated, as always.
Thanks,
J.O.

 
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
Curious interaction W/Win Exp. Jim H. Excel Discussion (Misc queries) 6 August 5th 08 09:38 PM
Macro interaction C Brandt Excel Discussion (Misc queries) 5 May 2nd 07 10:00 PM
Separating Business Logic from User Interaction (Userforms) chatterbox Excel Programming 0 November 24th 05 11:38 AM
Web interaction Nigel[_6_] Excel Programming 3 February 20th 04 08:34 AM
excel/asp interaction - HELP! Mark Bigelow Excel Programming 0 August 14th 03 11:49 PM


All times are GMT +1. The time now is 09:53 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"