Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default How to add a command button

Hello,
I recently starting using VBA. I'm trying to launch a user form I created.
I inserted this macro
Sub ShowForm(RequestForFunds)
End Sub
But when I try to run the macro the form does not launch.

I also need a book to help me; can someone reccomend a book to help me
learn VBA.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to add a command button

Maybe????

Sub ShowForm()
RequestForFunds.show
End Sub

use the correct name for the form

Marilyn wrote:

Hello,
I recently starting using VBA. I'm trying to launch a user form I created.
I inserted this macro
Sub ShowForm(RequestForFunds)
End Sub
But when I try to run the macro the form does not launch.

I also need a book to help me; can someone reccomend a book to help me
learn VBA.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to add a command button

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's is a nice one to start with.

Depending on how advanced you are...

Professional Excel Development
By Stephen Bullen, Rob Bovey, John Green

See if you can find them in your local bookstore/internet site and you can
choose what one you like best.

Marilyn wrote:

Hello,
I recently starting using VBA. I'm trying to launch a user form I created.
I inserted this macro
Sub ShowForm(RequestForFunds)
End Sub
But when I try to run the macro the form does not launch.

I also need a book to help me; can someone reccomend a book to help me
learn VBA.


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default How to add a command button

DP Perfect.... thank so much

"Marilyn" wrote:

Hello,
I recently starting using VBA. I'm trying to launch a user form I created.
I inserted this macro
Sub ShowForm(RequestForFunds)
End Sub
But when I try to run the macro the form does not launch.

I also need a book to help me; can someone reccomend a book to help me
learn VBA.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"