LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 414
Default first user form.....

hi all.
I've finished making my first user form with labels, textboxes, some
images-- for clarification-- and OK, Cancel buttons.

My first question is:
For my present (pre-user form) configuration, I'm using
application.inputbox(prompt:="...", type:=N) for my inputs (where N is either
1, 2, or 8 denpending on the requirements).

I've renamed all of my textboxes on my form to be identical to my inputs'
variable names.

What do I do with the application.inputboxes? What changes do I make here?

My next question:

If I understand this correctly, I'm to take my current sub, and place the
entire code within the code for the

Private Sub OK_Click()

'macro code goes here?

End Sub

code, correct?

Then, for my final question for this post:

What about the "control as IRibbonControl" within my paren's that allows me
to access this macro through the ribbon?
I'd like to keep it accessible through the Ribbon.


Thank you for your responses.
Best.
SteveB.

 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date field in user form & Loading a user form on opening workbook Balan Excel Programming 1 May 24th 08 03:40 PM
Call user form from ThisWorkbook; close file if form closed XP Excel Programming 2 July 20th 07 07:04 PM
Automatically add a textbox to a user form based on user requireme Brite Excel Programming 4 April 7th 07 11:37 PM
User form ComboBox Items: Remember user entries? [email protected] Excel Programming 0 March 29th 07 06:41 PM
How to: User Form to assign a user defined range to a macro variab TrevTrav Excel Programming 1 March 22nd 05 07:57 PM


All times are GMT +1. The time now is 08:29 AM.

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

About Us

"It's about Microsoft Excel"