Jump to content

VBA - Referencing a sub


wannabe

Recommended Posts

I'm not sure if I have used the correct terminology here, but anyway; what I want to do is creat a form that will execute two of my macros that are in the same project, and have already been created.

 

My form is laid out with the two buttons and label, and all that is required is for me to add the code to the two buttons that will call the subs.

Link to comment
Share on other sites

Also I might add, you can call a subroutine by using CALL YOURSUBROUTINE within the sub on the form. You can also (if you are calling a function - returns some value - instead of a sub)

ie iInteger = YOURFUNCTIONTHATRETURNSANINTEGER

Link to comment
Share on other sites

Also I might add, you can call a subroutine by using CALL YOURSUBROUTINE within the sub on the form. You can also (if you are calling a function - returns some value - instead of a sub)

ie iInteger = YOURFUNCTIONTHATRETURNSANINTEGER

 

Shouldn't that really be:

 

iInteger = YOURFUNCTIONTHATRETURNSANINTEGER()

:)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...