| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to activate the scrolling within the worksheet? | Excel Discussion (Misc queries) | |||
| How do I stop a worksheet from scrolling? | Excel Worksheet Functions | |||
| Stop scrolling on 1 worksheet | Excel Discussion (Misc queries) | |||
| Automatically scrolling to top of worksheet | Excel Worksheet Functions | |||
| Scrolling Marquee in a worksheet. | Excel Programming | |||
Linear Mode
