Last weeks I've had too few spare moments to answer questions, hope to pick that up soon. I have a strange problem now with some checkboxes on a multipage control.
Please see the attachment.
I want to check all the 5 boxes on a page if the box above is checked, and vice versa, uncheck them all if the box above is unchecked. I use code of Dave Hawley to loop through the checkboxes.
This doesn't work, but oddly enough, it works if I insert a MsgBox in the code.
UserForm1, page5. From Combobox1 I choose a city and the textboxes give me the values from Sheet3. I'd like to color in green the smallest value. for example, if for LHR I find for A-4214, B-4420, C-3127 => value 3127 to be green. The problem is I have more textboxes in other pages and some of them are colored in green also. Is possible to reffer to these textboxes from page5 only?
How do I determine which control the user is currently modifying on a multipage form (either changing, enterying or exiting the specific control). when I use "userform1.activecontrol" i get "multipage1" as the control name but I need the actual control on the specific active multipage. (also the .TABINDEX is for the multipage regardless of the on-page control) I use a generic data-field change SUBroutine so need the control name (and the TABINDEX) to provide my SELECT CASE. (so every fieldname_CHANGE calls the same SUB [with no parameters])
i have a userform which has more than 20 textboxes. these boxes need to accept numbers only. what codes can i use so that all the textboxes will be formatted in such way?
I am creating a bar inventory/"numbers" sheet for a corporation. I have been searching on and off for a week or so to find an answer or a tutorial on what I am looking to implement into this worksheet. I want to take a userform, with a multipage control, and have the control for each tab, show me a different part of the worksheets. For instance, the first tab would be inventory, the second tab would be ordering, the third tab would be weekly numbers, etc ... I am wondering how to "add ranges to the multipage control in order to make it a "viewer". I have found tutorials on how to print, enter info into the form and save it to the sheets using a button, but I can't find a tutorial on how to implement the control on how to make tabs show the ranges. Can someone point me in the right direction on a tutorial, or maybe if willing a small spreadsheet with a mulitpage control on it, showing how to add the ranges from different worksheets?
I'm using a multipage control on a form that has the style set to fmTabStyleButtons. So it uses buttons instead of tabs. I named one of my buttons (tabs) to Close. Can I set this up to where just pressing the Close button will cause it to exit the app not just go to that page?
i am trying to make the multipage form so that page 2 ,3 is password protected intially the form will open read only, with access to subsequent pages through a password.
I have a DTPicker on a multipage form on a userform with the following codes:
sheet1. range("Ac2").value=DTPicker1.value
DTPicker1.value=sheet1.range("AC2").value
The first line of code is in the DTPicker1_change event.
The second line of code is in the userform_initialize event.
This works fine if I move the DTPicker control onto the userform itself, but if I put the control on the multipage form it fails with the following message: Run Time Error 35788
An error occurred in a call to the Windows date & time picker control.
I have a userform with a multipage issue. On page1 I have a command button that formats cells. On page2 I have textbox1 with a fixed number, textbox2 that counts the number of formatted cells (from the command button on page 1) and textbox3 that's going to sum textbox1 and 2. So here's the issue. Lets say I'm on page2 viewing the textboxes, if I switch back to page1 and format additional cells and then switch back to page2, textbox2 does not update with the additional cells formatted. I always need to close the userform and reopen it for the changes to take place.
I've started experiencing a strange problem. The control toolbox keeps appearing when the first page on a multipage userform is activated. I can't figure out what's causing this, and after searching the forum, with no luck, I thought I would see if anybody else is experiencing the same problem, and how to fix it.
I have a userform which has a number of multipage controls nested inside each. So, the parent is Multipage1 with 2 pages. Page 1 of Multipage1 has a second multipage control (Multipage2 which has 4 pages). In Multipage2, page1 there is a 3rd Multipage control (Multipage3 which has 2 pages). In Multipage2, page 2 there is another multipage control (Multipage4 which has 3 pages)...and so on! I know this sounds complicated, but I am trying to get the caption of the selected multipage.
There are commandbuttons in all of the pages, which when clicked need to return the caption name of the multipage where they sit.
I have started the following code, but suspect there must be a better solution:
VB:
With Sales If .MultiPage1.Value = 0 Then Hardware_Purchases_Input.TextBox6.Value = .MultiPage1.SelectedItem.Caption & " - " & .MultiPage2.SelectedItem.Caption & " - " & .MultiPage3.SelectedItem.Caption End If End With
I want to access the Properties of a number of controls in a running form, and these controls may or may not be contained in a Frame or a MultiPage.
In particular I want the Top and Left for these controls, which means I have to first find out if the control is contained in a Frame or MultiPage so I can get the reference for Top and Left. I'm ok with doing this for controls inside a Frame, but the MultiPage is eluding me. I get an error when I try to access these controls and it looks like they are actually owned by the individual Pages of the MultiPage.
how do I find out if a given control is contained in a given MultiPage?
Have a slick way to have multiple textboxes on a userform updatable by a single calendar control located on it's own userform.
basically, i have a userform with multiple textboxes. A double click brings up another userform with a calendar control. How do you idenitfy which textbox called up the calendar?
I'm looking to perform a Find and Replace over all text boxes on all sheets.
I found this vba over at excel ribbon.tips which does the trick, but only works on the active sheet... I'm looking for it to work over all sheets. I'd also like it to look for 2 different instances.. For example, Find A replace B, and Find C replace with D.
I have a large workbook, with multiple sheets. I would like to be able to select a name from a drop down menu, and have the cell color change for all entries of that name in my other sheets. I can do it manually, but it would be much cleaner and easier to have Excel do it for me. I have looked at other answers here on this forum and know that if it can be done,
I'm trying to give a visual indication to a user of whether a combobox has been correctly filled out.
Basically I want the back colour to be red if the value is "Not Used" and green if the value is anything else.
Normally this wouldn't be a problem, I'd just use the combobox's change event to trigger a check, and adjust the backcolour appropriately.
However, the combobox is dynamically added to the form (depending on options further up the form) - and the particular combobox may not always be created.
I have a bunch of Option Buttons in a worksheet whose properties i need to change by running a macro. For example, I created an OptionButton1 in a worksheet using control toolbox. Now I want to run a macro to change it's name, groupname, linkedcell and caption. I did this macro but it doesn't work:
Sub Label() Dim Code1 As String Dim Link1 As String Dim Form1 As String Dim GroupName1 As String Dim Caption1 As String Worksheets("Section1").Select Form1 = "OptionButton1" Code1 = "FButton1" Link1 = "FLink1" 'Defined in worksheet GroupName1 = "FGroup1" Caption1 = "Choose Function 1" With Worksheets("Section1").Form1 .Name = Code1 .LinkedCell = Link1 .GroupName = GroupName1 .Caption = Caption1 End With End Sub
Im trying to create many option buttons on my sheet and then change the GroupName and Name properties but im having no luck in accessing the properties. Here is the code ive got at the moment, could someone tell me how to access these properties. Shown below is a small section of the code, if you require the full code i will happily provide it. This is my first post and im not sure if this code tag thing has been done properly:
n = 18 Call Section_Header Range("D" & n - 1).Value = " Case" For i = 1 To UBound(Name_Case, 1) Range("D" & n + i).Value = Name_Case(i) Range("M" & n + i).Value = Cost_Case(i) ActiveSheet. OLEObjects.Add(ClassType:="Forms.OptionButton.1", _ Left:=628, Top:=(n - 1) * 15.75 + (1 * 6) + (i - 1) * 15.75, Width:=46.5, Height _ :=15.75).Select Next i
i have 2 userforms one with textboxes and the other one with listbox and textboxes.
Everytime user input their data(ie:first name, last name, address etc) in the first form the data's going to be saved in Worksheet("customerSheet") and later on to be displayed in the second form. using the listbox you can select the customer's name and the customer info will be displayed in the textboxes.
Within the ComboBox properties, is there anyway to control after "enter" his hit, you move to the right instead of down (similar to the edit under Tools/Options)?
I have created a userform within VBA which has a TreeView Control and a Spreadsheet control on it.
I have populated the TreeView control with data and what I want to be able to do is to drag the nodes off the TreeView control to the spreadsheet control.
I can drag onto a normal worksheet but not onto the spreadsheet control (the no drop mouse pointer keeps showing).
I'm having a problem setting the multipage tab on a userform in VB. It's kinda weird because the code was working fine until recently, where it's suddenly stopped working properly! The only thing I can think of is that I changed versions of Excel to v2003 recently.
I want to not let the user change tabs unless the inputs entered have been error checked. My code is:
Private Sub MultiPage1_Change()
If Me.MultiPage1.Value > 1 Then If Range("inputs!dob") = "" Then Me.MultiPage1.Value = 1 MsgBox ("Please enter your date of birth before continuing.") End If End If End Sub The tab itself changes fine (ie. shows the tab 1 header), but the contents of the tab are actually the contents of tab 2!
I have had some succcess with Userforms, but I have now tried creating multipage ones.
I assumed that when I clicked on page 2 or page 3 of the multipage control, it would take me to a blank canvas, but instead it just replicates what is on Page 1. If I put textboxes and labels on page one, it repeats them on pages 2 and 3. If I delete boxes fropm page 3, they also disapear from 1 and 2!
So im unsure how to put different labels etc onto different pages.
