boxes

Hi All you Excel Guru's I need a little help. I am using four combo boxes from the Data Ribbon (Controls - Insert - Format Controls Combo Box (From Control). I would like to set it up that when the 1st combobox changes its selection that the other three reset. The problem is I am trying to...

1)Text boxes are starting from AB (Vertical Rectangle shape) ..this shape need to appear at every 4 columns automatically until AZ. start from AB/FG/LM/PQ---ETC only boxes need to be appear Please find the LINK below https://drive.google.com/open?id=1aZrjJeQQQO13bxmGUrY3DBtAshoxJIX6 Can i get...

<tbody> <colgroup><col width="41" style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;"> <col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="132"...

Hi, I have the code below but I am getting an error, the situation is I have two combo boxes in a userform and the boxes are filled in with data from my 'IN DAY LISTS' sheet, but it doesn't work when I added ComboBox1 coding below, please can you help me? I appreciate all your help with this :)...

Hi there, I have a UserForm with 50 Text Boxes that are named TextBox1, TextBox2 etc etc through TextBox50. Is there a way I can refer to the boxes using a counter? So I have a Integer Variable that increases by 1 based on some other code. Can I have something like TextBox(Counter).Value or...

How do I Copy the data from 3 separate combo boxes to 3 cells in Excel? I have 3 combo boxes on a user form, comboBoxFrame, comboBoxPanel, comboBoxEdging. comboBoxFrame is populated with a list of solid timber, comboBoxPanel is populated with sheet material, comboBoxEdging is populated with...

Hello, I got fairly easy problem one of you may know the answer too. I just couldn't figure out. I have a userform, when its triggered, text boxes get populated. The data in the text boxes are coming from cell values in another sheet. However when I execute my Macro in the other sheet where...

I have 8 list boxes on a user form but I want to make sure that the user always selects an option in each list box, my efforts have so far failed I initially tried by checking the list box had been selected by using... If LB6.Value = "" Then That didn't work, as when I stepped through the...

I have a form where I have 3 combo boxes and the data shows up. However when I copied the 3 combo boxes which are within a frame and pasted it into another form, the data doesn't appear?

Hello all, I am new to this site and am in need of some help. I have created a userform with 4 boxes for text entry and then submit and reset buttons. I want to have a button on the worksheet that will open up the userform which will then get filled out and the data entered into the sheet. Each...

Is there any way of moving a Dynamic Chart with tick boxes that control the visable data in to power point and the tick boxes and hard to still work

Hi, I have a file which used to work fine but now has a problem - the only difference is that I have upgraded from Excel 2010 to 2016 (which I guess must be the issue!?). The comment boxes and dropdown list arrows only appear momentarily (a quick flash on/off) with this particular file in 2016...

Hi all, I have a userform with text boxes for users to enter numbers, and I have labels set up to display the sum of the entries from those text boxes. If a text box is empty, it is throwing an error when the sum function is triggered. Is there a way to set the form to read blank text boxes...

In Word, you can the ruler to see measurements of tabs, indents & spacing. I know that the comment boxes in Excel do not have that capability. However, I'm fairly certain I have seen VBA code that does show measurements like this within comment boxes. Is there a "reveal codes" for text in...

Hi, I'm trying make have a sheet with drop down boxes which relate to the first 3 columns of the values below and basically make a singular formula that will look at the information from the drop down boxes and give me the code. I think its something along the lines of If Drop down 1 =...

This is my first attempt at building a Userform. It was actually going well and everything was working until I realized that one of my boxes was not posting a result. On the form I have a series of questions with Points awarded based on the answer. For example: It the answer to question 1 is...

Sheets("Job Tools").TextBox1.Value = Sheets("Analysis Update").Range("A2").Value Sheets("Job Tools").TextBox2.Value = Sheets("Analysis Update").Range("B2").Value Sheets("Job Tools").TextBox3.Value = Sheets("Analysis Update").Range("C2").Value Sheets("Job Tools").TextBox4.Value =...

Hi, I have the code below with the usual Application.ScreenUpdating incorporated but the screen still flashes/flickers when the code runs - everything (charts/tables etc.) momentarily disappear and re-appear when it runs so it doesn't look very slick. The page has a couple of charts reading from...

Hi Guys. I want to run something past you to see if this is possible. I want to create a form that has locations (cells) for me to type data into (Names, address info etc.). I also want to have a section full of check boxes within the form that when clicked, inserts a box of pre-written info...

I have a dashboard that I am trying to make nicer than just cell sized boxes. Is there anyway I can add formulas to SmartArt? I am using excel 2013