VB Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I found this code in one of my received file, could somebody help for what
this code is:

Private Sub SpinButton1_Change()

End Sub
 
Hi,

That isn't code, they are events relating to spin buttons from the Controls
toolbox that could contain some code.

Mike
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Error while updating an external data source into a pivot table! 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
Code to format cells on several worksheets 2
Outlook events stop work randomly 0
Excel VBA - Problem with Closing Print Preview 0
PowerPoint Help needed with VB 1
Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Spin button to scroll up&down a database with a userform 7

Back
Top