How do I show only used cells in a form?

Thespiv · Mar 3rd, 2002, 05:08 PM

I have created a User form but can't find how to show only the celss which have been used, I basically want to create a form that users can only access the fill in areas, check boxes or drop down lists?. I also want to estrict the usef from scrolling down any further than the bottom of the form etc. Can anyone help

Thespiv · Mar 4th, 2002, 04:28 AM

Just Dragging this to the top of the list incase the guy who has the answer is now up and about

Thespiv · Mar 4th, 2002, 07:17 AM

Still not solved

[ This Message was edited by: Thespiv on 2002-03-04 06:18 ]

Thespiv · Mar 4th, 2002, 11:33 AM

keeping this on top cos i really need an answer!

GeorgeB · Mar 4th, 2002, 01:03 PM

To restrict scroll area us this.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Me.ScrollArea = "H1:H50" Change to suit
'To set back to normal use:

Me.ScrollArea = ""

End Sub

Thespiv · Mar 4th, 2002, 02:01 PM

GeorgeB, computer expert, mastermind, and super hero, fear not folks for where others attempt to problem solve, GeorgeB dons the cape and lycra suit and fly's in as ExcelMan. Tough, Fearless and faster than a speeding cursor. So stand aside all you would be 'experts' cos as far as I'm concerned GeorgB is No1 superfixer exrodinaire.
As you can probalby tell George, it worked,, and I am extremely grateful.

Thanks a Million

Terry (Thespiv):->

GeorgeB · Mar 4th, 2002, 08:41 PM

You're very welcome. Pass it on and keep on Excelling.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 05:08 PM	#1
Thespiv New Member Join Date: Mar 2002 Posts: 31	I have created a User form but can't find how to show only the celss which have been used, I basically want to create a form that users can only access the fill in areas, check boxes or drop down lists?. I also want to estrict the usef from scrolling down any further than the bottom of the form etc. Can anyone help

Mar 4th, 2002, 04:28 AM	#2
Thespiv New Member Join Date: Mar 2002 Posts: 31	Just Dragging this to the top of the list incase the guy who has the answer is now up and about

Mar 4th, 2002, 07:17 AM	#3
Thespiv New Member Join Date: Mar 2002 Posts: 31	Still not solved [ This Message was edited by: Thespiv on 2002-03-04 06:18 ]

Mar 4th, 2002, 11:33 AM	#4
Thespiv New Member Join Date: Mar 2002 Posts: 31	keeping this on top cos i really need an answer!

Mar 4th, 2002, 01:03 PM	#5
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	To restrict scroll area us this. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Me.ScrollArea = "H1:H50" Change to suit 'To set back to normal use: Me.ScrollArea = "" End Sub

Mar 4th, 2002, 02:01 PM	#6
Thespiv New Member Join Date: Mar 2002 Posts: 31	GeorgeB, computer expert, mastermind, and super hero, fear not folks for where others attempt to problem solve, GeorgeB dons the cape and lycra suit and fly's in as ExcelMan. Tough, Fearless and faster than a speeding cursor. So stand aside all you would be 'experts' cos as far as I'm concerned GeorgB is No1 superfixer exrodinaire. As you can probalby tell George, it worked,, and I am extremely grateful. Thanks a Million Terry (Thespiv):->

Mar 4th, 2002, 08:41 PM	#7
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	You're very welcome. Pass it on and keep on Excelling.