userform question

[misterg]

good day,

just a very simple one...

i have a user form that has a few buttons on (each one emails data from sheet cells to a pre-addressed email recipient).

One question.
How do i get the userform to "find" the data on the one sheet in the workbook?
I need it to "look" for the open workbook called "whatever.xls" and select the sheet called "sheet1".

Any clues, its simple i know!

 

[Richie(UK)]

Hi misterg,

The following gets data from cell A1 on sheet1 of the workbook containing the userform. Is this what you mean?

<pre>
Private Sub CommandButton1_Click()
Dim MyString As String
MyString = ThisWorkbook.Sheets(1).Range("A1").Value
MsgBox "Data in Mystring is " & MyString
End Sub

</pre>

 

[misterg]

Richie,

Not strictly...i just need to take attention off the userform and direct the macro back to the sheet...i already have the exytraction code written for later on in the macro...its just merely directing attention back to the sheet...something like select workbook or similar!

Many thanks anyway!

Ian

 

[Richie(UK)]

Hi Ian,

If you just want to move focus from the userform to the workbook then try:

UserForm1.Hide

Or, to completely close it down:

Unload UserForm1

HTH