boxes

I have a form with about 10 check boxes on it that are ticked when answering the questions. I want a button that someone can press that checks all the boxes at once - i.e. a "yes to all" button. I also want one that clears them all as well. Can anyone suggest how to do this? Thanks :confused:

Hi I want to create a form which has 2 text boxes for First Name and Last name and one drop down menu which has Year of Birth, so user would enter First, Last and Year of birth and then excel copy that to excel. I know how to do the Text boxes, but not sure if I can do the Drop down menu. Is it...

I am trying to do a graph in Excel 2013 that uses custom dates that skips weekends along the Y axis. What I am currently using is =C26+IF(WEEKDAY(C26)=6,3,1) where C26 is the previous date and I have a list of ten dates using this. The only way that I have currently found to attach these dates...

This is my first attempt at using vba or activex controls so please bear with me. I created a command button in my document to use a macro (that I recorded) to copy these 2 boxes (merged) and duplicate them. It works well, but the new boxes appear above the old ones (where I drew the red line...

Is it possible have a command button that adds more boxes with the code below the existing ones? The user form has 3 rows, but it needs to have the ability to add more, since the project can have 40 jobs. User Form to create a budget., It contains the following boxes like on a row, one next...

I have several UserForms in my Excel workbook. After running one of them, I have noticed some very strange behavior. I have seen others post about it on a different site, but the solution offered to them doesn't seem like the right solution for me. Here's what is happening, in a nutshell: -...

The code bellow goes through my list of NAEDs and if the NAED is on the list it should activate combo boxes if the NAED is not in the list it should not activate the boxes. once this code finds a partial match it makes the combo boxes available i do not want that. It has to match the NAED in...

Hi I have this sub wich transforms all my unchecked boxes in checked boxes (R) in column B. Sub allewählen() Dim i As Long Dim lastrow As Long lastrow = Cells(Rows.Count, "B").End(xlUp).Row Range("B12:B" & lastrow).Value = "R" 'R = checkedbox End Sub How can I add exceptions...

Hey Folks I am running the following code so all shaded cells have to be filled out otherwise it won't let me save the excel file and so far I have this but seems not to work as it only works on some cells and only if some of that particular cell are selected and it is because of the For...

Hi I have 3 checkboxes in a sheet. I liked them to cells k2,k3, and k4. I created if statement, please see below. The only problem I have when use check more than one boxes. My if function does not handle this situation. I want to send a message saying "One box has to be selected at a time" How...

My old business partner thought comment boxes were a great idea. He is gone and I have these boxes that pop up when you are in a cell. However, they are not normal Excel comment boxes. I don't know what they are called, I can't edit or delete them. I'd prefer to get rid of them all together...

I have a .pdf from that requires the user to tick boxes, fill in text boxes, etc. I was going to recreate this .pdf form in an Excel sheet but I was wondering if VBA can tel the .pdf what boxes to tick, text to enter, etc from selections made via a worksheet? TIA

Good morning, I'm an Italian guy who uses excel for small jobs in the office, the problem that I can not solve is this: The file consists of a series of data in a column and I need the macro to do a count of the number of times a word appears in the column, then the macro in two other columns...

I hope someone can help me. ABC Company is responsible for processing and fulfilling repair claims for a luxury wristwatch manufacturer. ABC Company receives customer repair requests daily (7 days per week). The next business day, a box is sent from ABC Company to the customer with a return...

Hey I don't know if this is possible or not, but hoping it is We have an excel form we use at work, and it has legacy tick boxes in it. We would like to know the user of who ticked that box as they are approval boxes. If we replace these with active x controls, is it possible to...

Is there a way to write code to the X on a userform located in the upper right hand corner of the form. I have a few textboxes on my form that alerts the user with a message box if they did not enter a value in the textbox on exit. The problem that I am having is if the user opens the form by...

i have seen tutorials on how to set a userform to setup a database style worksheet ... but i need to move on a little to achieve my goal. my userform consists of a combo box with 3 choices named the same as 3 worksheets with the same book. under which is a text box for the date and 2 other test...

Ok, not so sure why this is harder than it seem but noting is working. I have been all over this BB and others and nothing works I have tried copying just adding the values. I have tried declaring variables I have tried something with LEN in it and several other things I can think of but...

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. Do any of you have any ideas or...

I will start by saying that I have successfully gotten a couple of VBA macros to work but I do not know what I am doing... I have added some combo boxes into a spread sheet. These boxes reference cells in a column that is defined. I can get the selection to work ie. I select Good from the...