Thread: userform
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick[_13_] Rick[_13_] is offline
external usenet poster
 
Posts: 18
Default 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?


.