Does anyone know if it is possible to extract a control name from a multipage on a userform upon actioning the control?
I have CheckBox1 and, when it is directly on the userform (no multipage), using the code Me.ActiveControl.Name returns CheckBox1 on click - which is exactly what I am...
Hi dear forum,
As you know, the MsForms Multipage control doesn't offer a built-in functionality for changing the colors of individual tabs. I have seen many requests for this functionality over the years and the usual workaround has always been to add some helper buttons\labels , to change the...
Hi! I have an inventory sheet with data. Then I have a book, where each page has multiple cells relating to a line item on the inventory sheet. Rather than manually link 100 pages, how to I duplicate each page and have the multiple cells magically refer to the next line item?
I really hope this is possible. I need to program a command button to send an email via Outlook...
I have multiple tabs on a multipage (each tab labeled as a product type)
In each page I have a long list of product in as checkboxes.
I need the "Submit" button to find all of the checked boxes...
I am trying to figure out how to take the items checked on a treeview and have them match the caption of a tab on a multipage userform.
In the attached woorkbook below is a moch-up of what i have in my project. The criteria userform...
Excel VBA beginner
I've prepared a userform with a two tab multipage area. I added several labels, textboxes and combo boxes within the first page but had not yet started any code work. I clicked outside the multipage form to edit some other objects and now I am unable to see the multipage tabs...
Looking for guidance on how to use mousemove event on a multipage?
Im trying to have a image as a button, and hover over changes colour.
Below code works for a userform mousemove, but can find a solution when over a multipage instead
Sub ExitButtonInactive_MouseMove(ByVal Button...
I have a userform with a multipage, and on each multipage I want to add a command button which opens another userform with a textbox to add notes. So far I have the notes linked to a cell on a hidden page, say "K5", and when there are notes on the page I want a checkbox to be enabled so the user...
I searched throughout this forum, and I'm sure I may have missed a similar post. If it exists, I'd be most appreciative if you'd direct me to where I may find it. :hungry:
So, here's the scenario. (I) Within a userform, I have a multipage with several tabs, all containing a...
I have a dashboard where col B is academic terms and col D is their total fees. I have a hidden sheet with the breakdown of their fees that I want to load on that multipage.
When a user double clicks a term in column B a multipage in a userform pops up.
So if Semester 1 is double clicked the...
I have a multipage with a label on page 1. I want the label to reflect what is in cell B5, but it doesn't do anything no matter what I try. Any ideas?
Private Sub FeesForm_Initialize()
Dim ws As Worksheet
MultiPage1.pgTerm1.lblTerm.Caption = ws.Cells("b5")
I'm using a Multipage (13 pages) on a UserForm and on each page I have 8 text boxes. These text boxes get calculated and the resulting value is entered into a cell on the worksheet. I have one set of controls (Enter, Calculate, and Clear) on the UserForm section. The 13 pages represent...
I have a sheet and when you click on cell B4 a multipage userform opens.
I was able to get the page captions to reflect a particular cell (i.e. Page1 = B4, Page2 = B5...) but they only change once you click on the page. So when the form opens it first says Page1, but when you click it, it...
I'm trying to programmatically create a page and a textbox within a Multipage control and I am receiving the following error - "Run-time error '13': Type mismatch
The code is as follows:
Private Sub btnReset_Click()
Dim pagNew As Page
Set pagNew =...
I am trying to get my Excel VBA UserForm to launch at page 3 on initialisation.
To accomplish this I inserted the following code into my project:-
Private Sub UserForm_Initialize()
UserForm1.MultiPage1.Value = 3
This produced the following error 'Run Time Error '380': Could...
I'm working on a fairly large (for me) project, using one (main) UserForm with a MultiPage. I was working under the mistaken belief that,
So most everything went into the UserForm Module. Things were going pretty well until I noticed the "fine print",
Ummm... right. :roll:
When I saw...
Im trying to pull images from hard drive locations into a userform multipage, but it displays the image behind the multipage.
I'm trying to put the picture in Image1 on the userform. This is what i got so far.
MultiPage1.Value = 0
Set img =...
So I have a userform that has a multipage control for user to input date that will be sent to a worksheet once a command button is pressed. How do I code the command button to send the data to the worksheet? Normaly it would be an ******* event that say takes the data from textbox1.value and...