userform
Hi,
Yes it's possible.
Sub ShowTheForm()
frmViewCells.Show vbModeless
End Sub
Private Sub cmdOK_Click()
Dim S2 As Worksheet
Set S2 = Sheets(2)
Me.txtNo1.Value = S2.Cells(10, 5).Value 'Col E, Row 10
End Sub
You could be on Sheet1 looking at a user form and viewing
different cells on Sheet2 as I have shown. This just
shows a simple example. Is that what you were trying to
do?
-----Original Message-----
hello everybody. I have a question: I need a userform to
have a cell or a
text box or whatever in which I can see the content of a
cell in a workbook
(i.e. =sheet!2 e10). is it possible?
.
|