T
Trevor
Hello All,
I have a form set up that is opened by a macro. Once the
user has selceted one of the option buttons, how can I
close the form, return to the original macro and use that
selection? The code snippet that I have so far is:
Sub RemarksReport()
UserForm1.Show
Workbooks.OpenText FileName:="G:\Collections\" &
UserForm1.ComboBox1.Value & ".txt", Origin:=437, _
StartRow:=1, DataType:=xlFixedWidth,
FieldInfo:=Array(Array(0, 1), Array(7, _
1), Array(34, 1), Array(45, 1), Array(56, 1), Array
(68, 1), Array(73, 1), Array(85, 1), _
Array(97, 1), Array(109, 2)),
TrailingMinusNumbers:=True
.....
End Sub
Any help is much appreciated.
Trevor
I have a form set up that is opened by a macro. Once the
user has selceted one of the option buttons, how can I
close the form, return to the original macro and use that
selection? The code snippet that I have so far is:
Sub RemarksReport()
UserForm1.Show
Workbooks.OpenText FileName:="G:\Collections\" &
UserForm1.ComboBox1.Value & ".txt", Origin:=437, _
StartRow:=1, DataType:=xlFixedWidth,
FieldInfo:=Array(Array(0, 1), Array(7, _
1), Array(34, 1), Array(45, 1), Array(56, 1), Array
(68, 1), Array(73, 1), Array(85, 1), _
Array(97, 1), Array(109, 2)),
TrailingMinusNumbers:=True
.....
End Sub
Any help is much appreciated.
Trevor