boxes

I've searched everywhere and can't seem to find an answer. I am trying to build out a macro off a userform where someone can select multiple items and when they hit OK all of those items (captions for the check boxes) will be entered into a specific location, preferably separated by a comma...

Hi, I have exported accounts data in excel from accounting software. Now stocks of the items are in Cartons (boxes); please help me, how to convert them into KG because record of all other items is on KG only. Please see attached excel sheet. I can get the sum of boxes for desired products but...

Hi All I am going to try and explain this a best I can. I am trying to create a spreadsheet for my football league. On one sheet I have a table of all the teams in the league and then individual tables for each teams showing the players. On another sheet I want to enter the results from the...

I have a SUMIFS-formula which here gets its criteria-input from two drop down boxes (in my actual formula 10+ boxes). The table has three columns, the "Sum_range" contains sales and then I have the two Criteria_ranges called "Region" and "SalesResponsible". The values in the drop down boxes are...

Hi, I'm currently working on a troubleshooting guide for our team and I've created a userform to be able to search using the 2 combo boxes that are dependent with each other. When clicking the Search button I wanted it to use the information on the 2 combo boxes to find it in a single worksheet...

Hi, I've created a userform with text boxes and check boxes but struggling to work out how to get the data transferred onto a spreadsheet via a submit button.

I have 700 check boxes in column F and have 2 macros already assigned to the check boxes. Now, I need excel to pull the UserName from the "Environs", convert it to the User's Initials, and post that in Column I in the same row as the check box. Is that possible?

Hi all, I have two list boxes and I want to fill one list box with the contents where the contents contain a unique ID from the other list box. Example list box1 contains ShopID and Shop Name and second list box would be populated with the ShopID and more details from the data in the...

I found these two macros on the internet. The first macro works fine. I have no problem with that. What I want is also this: When the check box is ticked, I want the cell that the check box is in to turn green. The second macro only works on one check box. It does not work on all of them...

I have a qty in Column E. I need a formula that will divide by 12 and then count the extra. I have 66 in Column E. I need 5 (for 5 cases of 12) in column G and 6 (for 6 extra boxes) in column H. Can anyone help with this?

Good Morning I have a number of Text Boxes All with the same name "Time1". I need to edit each of these boxes using VBA to remove the first character which is a Minus. Your help will be much appreciated. Regards Kev

Hi guys, hope everyone is having a great day, i need help with regards to my multi-tab userform on vba excel. I currently have 6 tabs and each tab there are are about 5 combo boxes, and a NEXT & CANCEL command button. I want a code that if the user forgets to click on one of the combo boxes...

Hi I have a sheet that has 20 boxes, 5 by 4, B4:D20, F4:H20... R58:T74 In each one has a serial number where my macro extracts an image from web into the box e.g B4:D15 = Picture, C16 = Serial Number and rest of box is information about serial number. Now I need to conditional format all the...

Hi Guys, Looking for a little help please. I have copied in a table from another source. The table has 500 lines of data. Each line of data contains a Checked box. I need to see which of the checked boxes are TRUE or FALSE. The table only has 4 columns with all checked boxes being in column...

I have a database of 4,000+ contacts and have check boxes next to each name in order to select for processing / copying, etc. Check boxes are in Column C and linked to Column AU after each contact's data. I want to use Check Boxes for as fast as possible selection of a contact. I manually...

So I have a Geographic Heat Map with Textboxes for all 50 states and 1 for DC. I need to see about adding to the following code to make the Textbox backcolor/fillcolor equal the state color. Sub Paint() Dim i As Integer For i = 1 To 50 'First, paint the state shapes...

I am fairly new to Excel for Mac. I created a workbook in Excel for Windows, and am now trying to make it work on Excel for Mac (both 2011 & 2016). My sheet has some radio buttons and check boxes. They seem to work fine on Excel 2016 for Mac. However, they aren't working on Excel 2011 for...

Cell D13 is blank when the worksheet opens up. Once(if) the end user enters a number into cell D13 that is greater than 1, row 14 appears. in Row 14, i have prompted the user to check yes or no to an option, both yes and no have check boxes. the issue i am running into at this point is that...

Hi All Got a simple userform - 1 combobox and 4 text boxes. The combobox has a list of all the sheet names. when a button is pressed, I would like the info that is in the 4 text boxes to be transferred to the next available row in the correct worksheet. is this doable? thanks neil

Need guidance with formula for inventory scenario Hi Team, Need your expertise with one formula... Scenario - I have 1700 no of boxes. each box has 12 packs/pieces inside. If I sold 75.4 (sometimes the boxes and decimal number will different as per the order) balance should be 1624.8 its by...