Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
Call user form from ThisWorkbook; close file if form closed | Excel Programming | |||
Automatically add a textbox to a user form based on user requireme | Excel Programming | |||
User form ComboBox Items: Remember user entries? | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming |