View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
jagexcel[_2_] jagexcel[_2_] is offline
external usenet poster
 
Posts: 1
Default how to select cell range with form?


ok, I figured it out.


Code:
--------------------

Private Sub CommandCancel_Click()
Unload Me
End Sub
----------------------------------

Private Sub CommandSelect_Click()
Range(txtStart.Value, txtEnd.Value).Select
End Sub
----------------------------------

Private Sub UserForm_Initialize()
txtStart.Value = ""
txtEnd.Value = ""
txtStart.SetFocus
End Sub

--------------------


--
jagexcel
------------------------------------------------------------------------
jagexcel's Profile: http://www.excelforum.com/member.php...o&userid=35657
View this thread: http://www.excelforum.com/showthread...hreadid=554395