1. I have text message on Excel Sheet 1. I have designed a form that has Multiple Check Boxes. Primary, CO-applicant and Co-signer vertically placed. And I have 3 Check Boxes that have been placed Horizontally Alerts, Public records and Mismatch Information.
What I am looking is I should be able to Pick 1 or all the 3 from Vertical Check Box which would be Primary, or co-applicant and Co-signer and also appropriately pick any from the Horizontal Check Boxes Alerts, Public Records and Mismatch Info.
For example: I the Text Box1 below should appear like this:
Primary: DOB Mismatch or and Bankruptcy any of those options.
Similarly for Co-applicant and Co-signer.
2. I have a Text Box2 on Comments page. The information from Text Box 1 Appears in Text Box 2. Once the form is run I am unable to make corrections if any in Text Box 2. Is it possible for me to edit the test that is copied in Text Box 2.
I have a hundred or more spreadsheets that I will be applying a utility to. I want to use one button on each sheet to call a form in the utility workbook. That form will have buttons that call individual parts of the utility.
I tried application.run("utility.xlsm!frmStart"). No dice.
I also tried: "utility.xlsm!frmStart". Same result.
How can I overcome this.
The reason I want my forms in a different workbook is the difficulty with maintenance and installation.
I've assigned a single macro to numerous Form Checkboxes (not ActiveX). I'd like the macro to be able to identify the Checkbox calling it, so that if for example, if it were fired by clicking "Check Box 41", the macro should know that.
Is this possible, or must I use an ActiveX control?
I'm trying to call a form I've created when the Print command is run (so when someone prints the document, the document number gets incremented.
I believe I have the command buttons setup correctly, as they aren't giving me any errors in the code, but when I do click the print button, the form isn't popping up. Could anyone give me a hint as to the direction to take?
I'm wondering if it's possible from a button placed on a userform to call the pivot wizard and then create a pivot table, which is then saved and imported into my form ??
I have a user form set-up that has four option buttons on it. I have them set so that when the user clicks on one of them the others are unset, however for some reason the user is having to double click on the buttons before they are set (with a black dot in them). It is as if the first click sets focus and the second click sets the button.
Can i amend it somehow so that the user only has to click once?
I have developed a 'Work In Progress' (WIP) worksheet containing space for several jobs. Each job has a group of option buttons in it which are NOT acting as triggers or code dependent (just for selection purposes).
Users are able to delete the entire job (12 rows) but the option buttons just move 'up'. I know how to delete these items by use of code if I could determine their name. But - can I programmatically determine the group name for the specific job/range that is going to be deleted.
Worksheet automatically is protected - there is no password.
Using the Forms toolbar control, NOT ActiveX, in Excel 2002 (XP Home) to make on option button, how do I obtain more than just one option? I can draw the outline of the button and I can rename the option but I don't know how to get more than one. I'm totally green to VBA/macros/code/etc. so please keep it SUPER SIMPLE.
I'm hoping that by selecting one of 4 options, IF formulas elsewhere in my workbook (spread over multiple sheets) can be fine tuned.
For Instance: if option 1 is chosen (on sheet 1), =sheet2!(randbetween(3,24)). if option 2 is chosen, =sheet2!(randbetween(3,30)), etc.
I'll then record a macro that will take it to a Value using CopyPaste Special. Unless there is slick way of stopping the cells from rerandomizing when the sheet is recalculated.
CHECK BOX
I hope to use check boxes, to help me CONCATENATE stuff elsewhere in my spreadsheet.
For Instance: if checkbox 1 is checked (on sheet 1), =sheet2!(conc($D$11&" whatever is associated with the check box). if check box 2 is checked, =sheet2!(conc($D$11&" whatever is associated with the check box), etc.
I try to make option buttons instead of round with a black dot but square box with check mark liked the check box. Box can be filled with color (light blue or other color). When the box is picked the fill change to white background.
I have 5 option boxs, I like to group them in one group because I have other groups using the option boxs. I want the check mak stayed in that group when it is picked.
I have attached my spreadsheet. Problem no.1:- I want to make all the sheets hidden except Main Index sheet.The concern sheet should gets visible when I select option box or Check box.
problem no. 2 I have given the data of Japan & China Plants. Now the total production of japan Plants are sum of plant 1,2 &3. But production of China plants are variable & need to fix by us. We will put production terget in China Plant 1, 2 & 3 in such a way so that one message box written "please check your data" should be appread whenever the K25/26/27/28/29 dont match with E25/26/27/28/29.
I have a form with at about 1200 checkboxes and I need to make them behave as radio buttons. What I mean is that just one box can be selected in a group of boxes.
Lets say i want to group all 1200 boxes in 400 groups, with 3 check boxes in every group. I want user to be able to select just one check box in every group.
Is there a way to set up a "watch" on a cell so that if you type in a different number on a cell, OptionButton1_Click() gets activated? Example:
A9 = 12.0104 OptionButton2 is active.
In Cell A9 you type "25.0508". OPtionButton2 becomes inactive and OptionButton1 becomes active. I already have the buttons linked, i just do not know how to make the button get triggered if A9 changes.
I have a survey template with several options buttons (made from Form toolbar and grouped by Group Box).I would like to have a check box that would activate these option buttons for specific question if unchecked and vice versa.
I have copy & paste below formula in VB, but is shows 'Run time error 424' & when I Debug it shows 2nd line highlighted by yellow colour.
VB: Private Sub CheckBox1_Click() If CheckBox1.Value = True Then [code]....
I have userform in excel which asks user to enter user id and password. I want a to have "Remember Me" check button on my userform which will remember user details and he wouldn't have to enter user id and password again and again.
I'm hoping there is some way to call whatever text is stored in the "alt text" field of images placed in an excel sheet for use as a variable / string reference in a macro.
The "alt text" will not be changed in any way by the macro.
I'm trying to use a VB code to insert check box in excel. I have 1000 records and i need to insert 1000 cehck box. I know how to do it manually for few but to do it for 1000 that just going to take too long.
I would like to create a form to select some columns from a list of columns. This could make it simpler for an end-user to chose which columns they want to see in my application. (see my previous question: [url]
Ideally, I would prefer to do that just like rows can be selected in an Excel list. However, I doubt this could be done.
So, to be practical, I would put a button on my sheet. When the user clicks the button, a form would appear and show the current list of columns. The user would mark or unmark to define his view and click ok to get the sheet with only the columns he wants. The number of column in the table can change. When the form loads it must determine what are the columns to include in the list (headers).
What I really don't know is which controls I should use on the form? Are there some list control with tick marks available, for example?
Or, I might dream of a mark-enables combo box or list box, as can be seen often on the web.
On the attached workbook i have a simple form with text boxes and a enter button and cancel button.
So far, i have only got as far as the cancel button closing the form. I want to know what i have to do to enter each of the fields in to the cells written on the form. Also when i do press the enter button, if any of the fields are not entered then a message box must appear notifying the user all the fields are not entered and then finish by taking them back to the form.
For some reason I only have the option of "keep text only (T)" in the paste options and cannot copy and paste formulas. Can you tell me how to change this and why this happened?
I have a userform that has 3 option buttons (1, 2 & 3) each of these option buttons have a Label next to them, Label (1, 2,& 3) next to that I have 3 textboxes that are formatted for currency. Each label represents a dollar value $10.00, $20.00 & $30.00
OptionButtom Label TextBox 1 Month Member x $10.00 $.00 2 Month Member x $20.00 $.00 3 Month Member x$30.00 $.00
When one of the OptionButtons is selected I want the corresponding label dollar value to be multiplied by the OptionButton and that value placed in the TextBox
i.e. if OptionButton 1 is select the TextBox would have a value of $10.00 if OptionButton 2 is selected then TextBox would have a value of $40.00 if OptionButton 3 is selected then TextBox would have a value of $90.00
Lastly, if 1 Option Button is selected and then changed to another of the 2 buttons, the TextBox value would reset to $.00
I have several option groups (Y & N in each) linked to cells to display TRUE / FALSE depending on which option is selected in each group. I have another cell which I want to apply conditional formatting to if EITHER Y or N is selected in all groups. At present I use COUNTIF to check for FALSE=0 in the linked cells which works if all the answers are Y. How do I apply CF if there is a mixture of Y & N (TRUE / FALSE) in all groups (I'm not sure if I've explained that well or not).
I have a sheet in which some of the cells have two strings separated by a linefeed. I have come up with a cumbersome formula which will let me check if either of the two strings is a member of a list stored on another sheet. However, it fails if there is only one string in the cell, presumably as there is no linefeed for the formula to find. How can I modify the formula to cope with this situation?
There are also on occasions, three strings in the cell, but I can't seem to access the middle string with the formula. Simplified spreadsheet attached to show the problem. This must be formula-based, as we have a no VBA policy. If you think there is better way of doing this, please let me know.
