C
c1802362
Hello, all.
I have a programming issue I can’t seem to get a handle on.
I have an application that launches a form (“LaunchForm”) that gives
the user a choice of picking either Radio Button A or B. Picking
either radio button assigns a string variable (“textvariable”) with an
appropriate value (StringA or StringB).
When I try to pass textvariable from the form to the application, it
disappears. Any suggestions? Here’s the basic code:
Option Explicit
Sub RunThisApp()
LaunchForm.Show
Range(“A1”).Value = textvariable
.........more code.....
Unload LaunchForm
End Sub
Here’s the code for LaunchForm
Option Explicit
Public textvariable As String ' I added the public statement to
the form since this is the first appearance of textvariable
Private Sub YesButton_Click()
If ButtonA.Value = True Then
textvariable = "StringA"
End If
If ButtonB.Value = True Then
textvariable = "StringB”
End If
LaunchForm.hide
End Sub
Private Sub CancelButton_Click()
Unload LaunchForm
Exit Sub
End Sub
Art
I have a programming issue I can’t seem to get a handle on.
I have an application that launches a form (“LaunchForm”) that gives
the user a choice of picking either Radio Button A or B. Picking
either radio button assigns a string variable (“textvariable”) with an
appropriate value (StringA or StringB).
When I try to pass textvariable from the form to the application, it
disappears. Any suggestions? Here’s the basic code:
Option Explicit
Sub RunThisApp()
LaunchForm.Show
Range(“A1”).Value = textvariable
.........more code.....
Unload LaunchForm
End Sub
Here’s the code for LaunchForm
Option Explicit
Public textvariable As String ' I added the public statement to
the form since this is the first appearance of textvariable
Private Sub YesButton_Click()
If ButtonA.Value = True Then
textvariable = "StringA"
End If
If ButtonB.Value = True Then
textvariable = "StringB”
End If
LaunchForm.hide
End Sub
Private Sub CancelButton_Click()
Unload LaunchForm
Exit Sub
End Sub
Art