Creating Dialog Box in Visual Basic with IBM Reflections

HarleyGuy

New Member
Joined
Jun 27, 2013
Messages
15
I have created a macro in IBM Reflections that uses Visual Basic for the code. I have the steps down that I need but I wanted to create a dialog box so that a chassis number could be used. Below is the VB code that I created:

' Generated by the Reflection Macro Recorder on 07-15-2016 08:18:36.43
' Generated by Reflection for IBM for Windows 10.0.244
'
With Session
.WaitForEvent rcEnterPos, "30", "0", 23, 8
.WaitForDisplayString "NEXT:", "30", 23, 2
.TransmitANSI "vmqa987995"
.TransmitTerminalKey rcIBMEnterKey
.WaitForEvent rcKbdEnabled, "30", "1", 1, 1
.WaitForEvent rcEnterPos, "30", "0", 23, 8
.WaitForDisplayString "NEXT:", "30", 23, 2
.TransmitTerminalKey rcIBMTabKey
.TransmitTerminalKey rcIBMTabKey
.TransmitANSI "5"
.TransmitTerminalKey rcIBMEnterKey
End With
End Sub

The third line starts with the command "VMQA" in one field and the next field is the chassis number "987995."

What I would like to do is once the VMQA is generated, a dialog box would come up to allow a user to enter in any chassis number so the user only needs to type that in rather than VMQA, Chassis number and the "5" at the end of the macro which brings the user to the page that has the information needed.

I've tried some variations using InputMsg but it bombs out.

Any help would be greatly appreciated....
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,215,237
Messages
6,123,800
Members
449,127
Latest member
Cyko

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top