Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Code
I found this code in one of my received file, could somebody help for what
this code is: Private Sub SpinButton1_Change() End Sub ------------------------------------------------------ Private Sub SpinButton21_Change() End Sub ------------------------------------------------------ Private Sub SpinButton23_Change() End Sub ------------------------------------------------------ Private Sub SpinButton7_Change() End Sub ------------------------------------------------------ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Code
Hi,
That isn't code, they are events relating to spin buttons from the Controls toolbox that could contain some code. Mike "Hassan" wrote: I found this code in one of my received file, could somebody help for what this code is: Private Sub SpinButton1_Change() End Sub ------------------------------------------------------ Private Sub SpinButton21_Change() End Sub ------------------------------------------------------ Private Sub SpinButton23_Change() End Sub ------------------------------------------------------ Private Sub SpinButton7_Change() End Sub ------------------------------------------------------ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Code
yes. when I keep my cursor on them its cell value is
"=EMBED("Forms.SpinButton.1","")" - Mike could you please tell me what they do or how I can use them? Hassan "Mike H" wrote: Hi, That isn't code, they are events relating to spin buttons from the Controls toolbox that could contain some code. Mike "Hassan" wrote: I found this code in one of my received file, could somebody help for what this code is: Private Sub SpinButton1_Change() End Sub ------------------------------------------------------ Private Sub SpinButton21_Change() End Sub ------------------------------------------------------ Private Sub SpinButton23_Change() End Sub ------------------------------------------------------ Private Sub SpinButton7_Change() End Sub ------------------------------------------------------ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Code
Show the Control toolbox toolbar (View|Toolbars in xl2003).
Then click on the Design mode icon on that toolbar Then rightclick on the spinbutton you want to experiment on (in a test workbook!!!). Choose properties. Play with these properties Min Max SmallChange Linked cell (type A1 here) Then close the properties window. Click on the Design mode icon to get out of design mode And click away and watch the linked cell (I chose A1) change. Hassan wrote: yes. when I keep my cursor on them its cell value is "=EMBED("Forms.SpinButton.1","")" - Mike could you please tell me what they do or how I can use them? Hassan "Mike H" wrote: Hi, That isn't code, they are events relating to spin buttons from the Controls toolbox that could contain some code. Mike "Hassan" wrote: I found this code in one of my received file, could somebody help for what this code is: Private Sub SpinButton1_Change() End Sub ------------------------------------------------------ Private Sub SpinButton21_Change() End Sub ------------------------------------------------------ Private Sub SpinButton23_Change() End Sub ------------------------------------------------------ Private Sub SpinButton7_Change() End Sub ------------------------------------------------------ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Code expantion , with code! | Excel Discussion (Misc queries) | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
Need 2 add second then third code with first code in the Tab View | Excel Worksheet Functions | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |