Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need some help with userforms
Private Sub CommandButton1_Click() If CheckBox1 = True Then Unload UserForm1 Sheet2.Activate UserForm2.Show Else End If End Sub "userform1, in sheet1, contains the above code. So when i select the checkboox "true" and click on the command but...then it unloads userform1, activates, sheet2 and loads userform2....everything is working perfectly...this far....then userform2 contains the following code: Sub UserForm_Initialize() LabelZoom.Caption = ActiveWindow.Zoom With ScrollBarZoom 'zoom .Min = 10 .Max = 400 .SmallChange = 1 .LargeChange = 10 .Value = ActiveWindow.Zoom End With With ScrollBarColumns 'horizontal scrolling .Min = 1 .Max = 256 .Value = ActiveWindow.ScrollColumn .LargeChange = 25 .SmallChange = 1 End With With ScrollBarRows .Min = 1 .Max = ActiveSheet.Rows.Count .Value = ActiveWindow.ScrollRow .LargeChange = 25 .SmallChange = 1 End With End Sub Sub ScrollBarZoom_Change() With ActiveWindow .Zoom = ScrollBarZoom.Value LabelZoom = .Zoom & "%" .ScrollColumn = ScrollBarColumns.Value .ScrollRow = ScrollBarRows.Value End With End Sub Sub ScrollBarColumns_Change() ActiveWindow.ScrollColumn = ScrollBarColumns.Value End Sub Sub ScrollBarRows_Change() ActiveWindow.ScrollRow = ScrollBarRows.Value End Sub Sub userform_terminate() Sheet1.Select UserForm1.Show End Sub "with this code the userform2 allows the user to zoom & scroll the active sheet2 with the controlls on the userform....and when I close the user form it terminates the userform and loads userfrom1 in sheet1 again...working perfectly but when i repeat the cycle userform2 loads perfectly within sheet2 but non of the controls to scroll or zoom the sheet that i have created on the userform2 seems to work.....???? -- T.c.Goosen1977 ------------------------------------------------------------------------ T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...o&userid=35895 View this thread: http://www.excelforum.com/showthread...hreadid=557219 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to see only youre userforms?? | Excel Discussion (Misc queries) | |||
userforms broblem | Excel Worksheet Functions | |||
Userforms & Pocket PC | Excel Discussion (Misc queries) | |||
Creating UserForms | New Users to Excel | |||
Open Userforms from a Dropdown list | Excel Discussion (Misc queries) |