boxes

Hi Everyone So I need to get some names and make userform inputs so heres what i need, I have 5 Cells with headers and 5 cells which need readings I have userform1 I want to take userform1 and Place the headers from Cells A10,C10,E10,G10,I10 to header boxes Below the header boxes I have Input...

I have a bid form that works, but the code is cumbersome. I have a column of check boxes called "include", a column off the same called "Exclude", a column of items to be included or excluded, and column of notes for the item. After selecting the check boxes i have code that adds the selected...

<tbody> Team1 Team2 Team1Run Team1Over Team2Run Team2Over Tie? NR? </tbody> I have this form to be filled by a VBA form. I followed many VBA Form codes but unable to correctly enter data into the form. This form is located in sheet MatchData starting cell A1. I have a form...

Hello all, I am calculating multiple text boxes on a user form and the code i am using seems to be working out okay. The problem i'm having is if I tab into the text boxes that have the code to multiply and divide are left blank are giving me a error message. Some days I may leave those text...

If I hide rows on my spreadsheet which have check boxes on them, the check boxes do not disappear, they appear to stack up behind each other Is there a way to also hide these check boxes? I am using VBA to hide the rows so a VBA bit of code to hide the check boxes would be perfect! TIA

I've inserted a Form control check box in sheet "Start sheet". This check box is made up of 9 rows & 2 columns ( cells K26:L34) with the names of continents [column K] so that a user can select one or more [tick boxes in column L]. I would like to use vba to step through these check boxes and...

Bear with me as this is not my forte with Excel! I am composing a simple excel sheet for users to complete, I have started using check boxes but what I need is if a user ticks a box, they have to select an option from a list, and the response is populated in a cell somewhere. I know how to use...

Hi All I have a Office 365 spreadsheet with 23 check boxes for categories for sweets (the check boxes either hide or show a row in another sheet). I also want to add a couple of check Boxes that will select all the "chocolate" (checkbox 24) sweets and deselect the remainder or select all the...

Hi I'd like to load Excel BuiltIn Dialog Boxes by using the following line of code or similar and where the strDialogBox variable contains the name of the Dialog Box to load. strDialogBox="xlDialogFontProperties" Application.Dialogs(strDialogBox).Show How would I do this? I'd like to open...

Hi, I'm very new to VBA and was wondering if somebody could help me with the following I have a user form with multiple combo boxes and text boxes. One of these combo boxes has three options, all entered via VBA If the option of Hotel Supplies is selected (and only this option), I want to...

I normally use a string variable (Var_MsgText) as an input to message boxes but I'm currently writing my biggest piece of code to date that has multiple subs that all use message boxes. I don't want Var_MsgText to be a public sub as that would risk incorrect carry over of the content between...

Wondering if anyone can help. I want to create a user form with two active x text boxes. In box one you put a number and the second box uses a formula to change the number and display the result. For example put 2 in box one and it shows 100 in box 2. There are many other boxes on the form but...

I've been building up an organizational chart for where I work using the Excel SmartArt. Currently I'm using the Name and Title template. I was wondering if it is possible to somehow add additional titles to all the boxes. Below is a quick example similar to what I currently have built up. I'm...

Hello, I have created a user form with 3 combo boxes and a DTPicker. The combo boxes allow me to select Name, Day and Price. Whichever day is selected determines which worksheet the data is stored on i.e. Tuesday goes to Tuesday Worksheet, etc. My problem is with the second user form, which...

Hi All I have sheet 1 with many (around 150) check boxes. These check boxes operates 150 macros on sheet2, sheet3 and sheet4. These sheets are password protected. Each marco is with IF ELSE condition. Is there any way/vba code that as soon as i go to sheet1, all remaining 3 sheet gets unlocked...

I am creating a standard operating procedures manual for my employees. Needless to say there is a lot of text, and Word would be a more appropriate tool for this project. However, Word has a critical shortcoming as it does not allow freeze frames like Excel (I do not want to use Split View)...

Is there a way to place multiple hyperlinks in a single text box? Every time I select some text to make into a hyperlink, it makes the entire text box the link. I have a long Excel workbook comprised of long text boxes for ease of alignment purposes. I'm using Excel instead of Word because...

Remember I'm a newb so if I sound ignorant it's because I am, lol. Ok so I'm creating a simple user form that will be using a bunch of text boxes to input data into specified cells. So the code for each one of the text boxes look like this: Private Sub TextBox1_Change() Sheet3.Range("b1") =...

I have check boxes that have worked for a long time but stopped working today, I believe, only on my PC. I shared a copy of the file with a coworker yesterday and the check boxes work on his computer. I have each box linked to a cell and all the cells are unprotected. When I try to check the...

I like blue as much as anyone but not for geometric shapes like lines and boxes. How can I change the default color to, say, black?