box

Hi All Before i get to involved with mu approach. Is this even possible. In a userform i have a combo box linked to a named range in a sheet. 8 options. I then want another combo box that displays a variable named range dependent on the previous combobox for instance combo box 1 has the 8...

Hi I'm running Windows 10 and Excel 2002 (don't ask why). I like to be able to open multiple instances. At the moment, if I check the "Tools/Options/General/Ignore other applications" box I get separate instances when clicking on successive file icons (which is what I want), but the workbooks...

I have a textbox that has the text "Please type notes here" and a button that prints to pdf. If no notes are written in the textbox, a blank text box with the text "Please type notes here" will still appear when I print to pdf. How do I make the text box invisible if it contains the text "Please...

Hi all, I need to pass a value from a text box (frmkeypad.tbvalue.value) to another text box in another userform. But the form name and text box name to pass it to are stored as public variables (formref and fieldref). So something like formref & "." & fieldref & ".value" =...

I have a combo box on my user form and I can not find it anywhere. I have used code to move it and make it colors and visible to locate it to no avail. Is there some code to just delete it so I can add a new one? Tired of looking for it. Thanks

In column CB I have list of items then CE has their respective values. Now the items in CB are grouped into four - meaning each group has same value. So I need a way to display with a message box - VBA: Group 1 = Value 1 Group 2 = Value 2 Group 3 = Value 3 Group 4 = Value 4 I have been...

OK Excel gurus, I have a spreadsheet I want to use a text box change event to dynamically filter the table by the data in the text box as it is entered. Also I would prefer if it searched through all the table columns so I can search using different data points and still find it hopefully...

Hi, When I right click on a cell I get a drop down menu and a box containing tools above or blow it, I would like to customize this box of tools and the drop down menu also, is this possible. Thanking you in advance. Regards, Duncan.

Good Afternoon all, I have a VBA macro that allows for data being entered into a text box to be placed in specific areas of my sheet. However, when I click "OK" with no value entered (blank), it ends the sub. I need the sub to stop running when it finds a blank value on the sheet, but when no...

Dear Excel Experts I need urgent advise on how to do a custom search input text in combo box under protected sheet. The property of combobox is unlock as well as all the cells link to that box are unlock. Below are vb code for this combo box. Private Sub ComboBox1_GotFocus()...

Ok, so what i am trying to do is to use a vb form to view ranges on a worksheet. i dont want to change anythin but i do want to scroll through to the last row that has data. that being said, i have literally tried everything i can think of short of just writing a java script and doing what i...

Is it possible to have a spreadsheet, whereby in cells B3:B22 (for example) you have "Hidden" answers, and in A1 you have a text box, you put an answer in, and press enter. If it matches, then it highlights the answer, and clears the cell for the next go. So, in B3:B22 you could have the...

I have a table and the first column for a row is the date. If a date is entered that is earlier then today's date, a message box should appear and ask you if that is what you want. It is just to add an extra layer of protection against typos. If a new row is added then a date entered that is...

Hello, Please I need your help with my project. I have made a system for my business and need to add some forms using different tools and entry methods The form contains: Text Box Combo Box Option Buttons Check Box Commend Button Once I open the form to add a new Item... 1- TextBox1...

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...

I need help, I have a Quotation that I have made for work. It has drop downs Lists to save time and speed up the completion of the quotation. Problem is I have added a drop down List under subtotal is for offers like 20% off ect. the one I'm having trouble with is the free packing material...

The SQL statement works in the query grid but not in the vba. I want a search box to pop up and I will enter the EquipID into the search box then it will load the correct records into a list box for that EquipID. See below for the SQL Statement. strSQL = "SELECT tblTag.TagNumber, tblTag.TagID...

Hi, I'm not sure if i have the correct title on this thread, here is what i am trying to achieve. I have 4 shipping templates. 1. Flat Rate Envelopes 2. Small Box 3. Medium Box 4. Large Box I also have an excel sheet that has products, each product has one of those shipping methods above...

Hey Guys ! Can any one help me out, i am stuck with a problem I have a list of codes in Sheet1 from A1:A1000 I want that list to populate as list ( Data Validiation ) in Sheet2 from B1:B1000 ( but from B1 to B1000 the list should be searchable ). As in when B2 is selected then selecting codes...

Trying to modify an existing spreadsheet that iis filled with values from an index/match on a pivot table. I'd like to make a double click function that displays the data row details in a message box. It gets tedious to verify the values from the pivot table by going to the pivot table and...