boxes

Hi, I am relatively new to VBA user forms, i am trying to create a form with multiple check boxes that will automatically update a text box at the bottom of the form with the total value associated with the check boxes that have been selected. I have no code to share at the moment as i am unsure...

I have a table and two text boxes and I want to be able to write a name and a price in them, then press a button and copy them to a table on another sheet. The table name is: Services. I started with this code, I thought I needed to dim a few variables to hold the values of the text boxes...

Hi. I have been trying to loop through around 300 text boxes on a form to apply conditional formatting with little success. I have populated the text boxes with the following code: [code] TextBox18.Text = Application.VLookup(ComboBox1.Value, Range("C4:NK76"), 7, False) TextBox19.Text =...

Hello all! I have a spreadsheet that I entered a check mark (letter "a" in Marlet font) into set boxes. I want to write a formula that tallies all those boxes containing an "a" check mark in a given row. How would I write it? Below is an example of the boxes- although it didn't copy right...

Good morning. Apparently my last question was a bust and was probably confusing. Luckily I figured out how to do what I needed. Now, My issue is that I want to have the form close and reopen (I think that's the easiest avenue to take) after the user scans data into the 2nd text box. Currently...

Hi All you Guru's! I am having a little trouble with my use form. The form has 5 combo boxes and 12 check boxes. All my links work and everything seems fine with the exception of when I open the user form all the boxes are blank. So If I select 5 check boxes and then close it and then reopen...

I have a drop down box of three options, each one of which has a different % that needs to be added to a rate when selected, how would i go about attaching this % amount to the rate via a formula when selected?

I have 42 list boxes. When the file is opened on a different PC and then i reopen it on mine the font shrinks. Is there a way to loop through all 42 boxes when the file is opened and set the all to font size 24?

Hello All! Thanks for reading first off What i want to beable to do is have two combo boxes on a form which when i select a Zone then the second combo box only shows details assoicated with that Zone. I have looked at this video on you tube https://www.youtube.com/watch?v=pMiJHhjzC8Y With...

I have a few simple list boxes, one showing a list of vendors and the other showing a list of months. Every time I save and exit the workbook, the list boxes shrink from the bottom so when I reopen said workbook, some of the options inside the boxes are not visible. How can I get these list...

Hello All- I have a userform with a few text boxes. Two of the text boxes are used for time inputs. I'd like the times to be put in formatted as military times (0001 or 1040 or 2304 (no colons)). These textboxes input data into a few excel boxes on "Voyages" sheet. How would I format that? Thanks

Hi I want to set up a general general RFQ compiler using Excel. I would start with a table and manually input part numbers. Then I would use a macro to input suppliers and prices. There could be 20 parts in total but some suppliers might only be quoting for 1 or 2. I am thinking of using...

Hi Everyone, I'm working with Text and Combo boxes on a Tabstrip in a Userform. I have multiple Tabs on which the user will input data and then click a button to write the data to various worksheets. So far so good. My problem is that because Tabstrips share the same controls I want to reset...

Hello everyone, Thanks for visiting my post. I'm hoping you could help me make the ultimate work scheduler. Please note the empty boxes... I've set "conditional formatting" to color fill each box once data is inputted. Please refer to photo I was really hoping there was a way I could use...

I'm trying to sum quantities (C7) from multiple sheets (Sheet2:Sheet11) onto a summary sheet (Sheet1) using check boxes. I have the check boxes (G6:G15) set up on Sheet1 but when I check more than one box it only shows the topmost checked value. I need it to sum the values whether I check one or...

Hi all, Apologies, I'm new to this and new to coding so I will sound as though I'm clueless! Im creating a userform through VBA and I need to get some of the boxes I have created (label boxes) to add up the value that is in the text boxes (in some cases I need them to multiply). Does anyone...

I have 2 drop boxes. They were created with the developer insert, form control and i have them linked to graphs whcih update upon changing the option in a list. i am using a Choose(cell, list name, list name etc....) Each drop box referneces the same list of items but the results differ as...

Hello everyone, Need assistance on syntax to write a common value to different text boxes. My Userform has 25 text boxes, renamed "TB1", "TB2,...,"TB25". Each box has an extra box on the side where users will be entering serial numbers. The macro process fills a varying number of "TB" boxes...

Follow up from a (very) old post: https://www.mrexcel.com/forum/excel-questions/322118-disable-password-prompt-upon-opening-spreadsheet.html I wondered if someone could advise if its possible to de-activate the password prompt. I have a macro in place to link all the sheets to my master sheet...

Hi, i have one user form which has 10 image boxes or image controllers. I want to run a loop to upload pictures to these image boxes. How to so that? Image1.picture = Loadpicture(imagepath) i am not able to place i (where i = 1 to 10) as Image i.picture = Loadpicture(imagepath i) please help