Results 1 to 3 of 3

Thread: Macro to Run from Command Button

  1. Oct 4th, 2005, 07:37 AM #1
    br_turnbull
    br_turnbull is offline

    Thread Starter
    New Member
    Join Date
    Oct 2005
    Posts
    4

    Question Macro to Run from Command Button

    I have a macro (module) made in excel, I have also created a VB Project as I want a GUI to get certain variables from input that can be passed to the macro. Giving it more functionality as the msgbox available wont suffice. Basically i have some Check box values, and two dates to pass to the macro (module), then execute the macro by clicking a command button. How would i go about this?
    Reply With Quote Reply With Quote
  2. Oct 4th, 2005, 08:49 AM #2
    Chris67
    Chris67 is offline
    Junior Member
    Join Date
    Sep 2005
    Posts
    24

    Re: Macro to Run from Command Button

    Hi
    Is it possible to convert your VB Project to an ActiveX Control or a Librariy?
    where you can use as a Reference in your Excel VBA ?

    Chris
    Reply With Quote Reply With Quote
  3. Oct 4th, 2005, 12:53 PM #3
    zaza
    zaza is offline
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Macro to Run from Command Button

    Alternatively, create a Userform in VBA and put the code in there (which may be some work, depending on how much code you have). Then you can run the entire thing through Excel.

    zaza
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width