Scrolling worksheet
 

I need to scroll worksheet while using my data entry userform. How Can I
do that? Please help me.


--
rahul25
------------------------------------------------------------------------
rahul25's Profile: http://www.excelforum.com/member.php...o&userid=28899
View this thread: http://www.excelforum.com/showthread...hreadid=486468

Scrolling worksheet
 

The following will select the entire row, change the value xr to the row
required, by this method as you pass new values in xr the sheet shows a
horizontal scroll bar highlighting the row.....

Rows(xr).EntireRow.Select

You can also do it for columns by using ....

Columns(xc).EntireColumn.Select



--
Cheers
Nigel



"rahul25" wrote in
message ...

I need to scroll worksheet while using my data entry userform. How Can I
do that? Please help me.


--
rahul25
------------------------------------------------------------------------
rahul25's Profile:
http://www.excelforum.com/member.php...o&userid=28899
View this thread: http://www.excelforum.com/showthread...hreadid=486468

Scrolling worksheet
 

Hi Rahul25,

Show the userform non-modally, e.g:

'===========
Public Sub Tester
UserForm1.Show (False)
End Sub

'<<===========

---
Regards,
Norman



"rahul25" wrote in
message ...

I need to scroll worksheet while using my data entry userform. How Can I
do that? Please help me.


--
rahul25
------------------------------------------------------------------------
rahul25's Profile:
http://www.excelforum.com/member.php...o&userid=28899
View this thread: http://www.excelforum.com/showthread...hreadid=486468

Scrolling worksheet
 

Thank you guys. I belive I got it already what I was asking. I need just
make false to "showmodel" in the userform properties. Thankyou guys.


--
rahul25
------------------------------------------------------------------------
rahul25's Profile: http://www.excelforum.com/member.php...o&userid=28899
View this thread: http://www.excelforum.com/showthread...hreadid=486468