Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / January 2007

Tip: Looking for answers? Try searching our database.

Hard Coding A Button Using "Buttons.Add(x1,x2,x3,x4)"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
robinson.william@gmail.com - 03 Jan 2007 15:13 GMT
Hi all,

I'm writing a Excel sheet that requires a button to be inserted for a
certain situation in a macro. I didn't know the instructions to create
a button so i recorded a macro that did what i wanted then looked at
the generated code. The recorded macro gave me this:

ActiveSheet.Buttons.Add(x1,x2,x3,x4)

where x1...x4 are numbers. Does anybody know what these numbers are
for? I can't seem to find it in the help menu.

Thanks
Bill
missinglinq - 03 Jan 2007 15:23 GMT
This is a MS Access forum; you need to post this in an Excel group!

Good Luck!

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.