box

I’ve been looking for a code this evening without any luck. On my worksheet called SHEET1 in column A is a list of customers names. I need to be able to search for a certain customer where I have limited information on them & be able to select them from a list box. It would work something...

So I've got a bunch of comments in a spreadsheet and all the comments are of variable length. I try not to change the size of the default box if I can avoid it cause I've noticed if I increase the size or move it, the next time I look at that comment, the box has changed size and I have to...

I have a table with Sku and Item Name. There are multiple lines with the same Sku. I want to take this information and create a table showing one line for the sku name and place an "X" with the Item Name that make up the Sku. Beginning data table <colgroup><col><col></colgroup><tbody> SKU...

Hi All. I've trying to code the following but not yet managed it! I'm looking to filter a data range let's say A5:C200. The criteria will be the value of a drop-down box in D1 selected by the user. The value will only be contained in one of the columns. As always, any help appreciated. Thanks

I have made a data form which I would like to always show on "sheet1" and add new lines of data to "sheet2" horizontally so I can then work with the data without having people mess with it however I keep getting debug errors. I have tried looking online however everything i find is too...

Hello all... I have code for a searchable combo box, that is working just the way I want it to. Private Sub ComboBox1_change() Dim i As Long For i = 1 To Application.WorksheetFunction.CountA(Sheet2.Range("a:a")) If LCase(Left(Sheet2.Cells(i, 1), 1)) = Me.ComboBox1 And Me.ComboBox1 <> "" Then...

I'm using the code below and today's date is pre-populated in the Input box. Is there a way to make it today() - 7 days? thanks! Sub DeleteFromDate() Application.ScreenUpdating = FalseApplication.DisplayAlerts = False Dim LR As Long LR = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row...

I would be grateful if there are any suggestions - I have been wrestling with this for several days. I am try to use a UserForm called from VBA to offer a drop down list for user selection. When I create this Userform with a Combobox the box appears but there is nothing in it? So I went for...

I have a text box that has default text that disappears when you type in the box. What vba code would make the box invisible when printing if it contains the text "Please type notes here"?

I have an activex text box that I need to expand down as more text is entered. It is set to a width of 540 and when text reaches the edge, I want it to go to a new line and for the text box to grow one line larger. If it is deleted, I need it to shrink the text box to fit. It must stay at the...

I have a workbook with 4 sheets. First sheet is called "Main" Second Sheet Is called "Heavy Used Belting" Third Sheet Is called "Medium Used Belting" Fourth Sheet Is called "Light Used Belting" On "Main" I have 3 categories and 6 buttons. The categories correspond with the heavy, medium...

Hi Experts, In Excel when i go file - option - advanced - When calculating this workbook option-- check box - Use 1904 date system.. Can i know what is that and use?

Hi, I'm very new to VBA and was wondering if somebody could help me with the following I have a user form with multiple combo boxes and text boxes. One of these combo boxes has three options, all entered via VBA If the option of Hotel Supplies is selected (and only this option), I want to...

Is it possible to increase the height of a active x control text box as you type in it. This would mean that it appears to expand downwards. I tried the auto size feature but this just shrunk the text to squeeze it all in when you deselect the text box.Is it possible to make it just stay...

I have a check box to increase a quote by 10%. The formula is multiplied by a cell that contains a 1 or 1.1, depending on whether the check box is selected. I have the following code that won't work, what is wrong with it and what is a more efficient way to write it? Private Sub...

I have a text box on my spreadsheet with some text in it, "Please type notes here", and when I click in it, I want the text to disappear. Is there a way to do this?

Hi all, Excel sometimes hangs on this dialog box This happens at the end of a loop and in this instance, it successfully completed 55 iterations of the loop before it got stuck here. Any ideas how to prevent this without disabling the save? I'm ok with it skipping one, two or even three...

I have the user form with text box and list box With the below code I am trying to search the customer number while the user enter the name in text box 11 and the list box will display the result. But this code is not working. In column B the name is entered and it starts with row 7. The list...

I have a code that loads a value into 2 text boxes when you choose a part # in t lit box. I would like to modify the code so that it sees the part #in the list box and loads the text box, instead of upon selection of the part #. Can someone shoe me how to make the modification? Private Sub...

I'm wondering if anyone can help me consolidate this. I have 59 checkboxes on a worksheet. They are all ActiveX controls that run the following code. Each is unique. The purpose is if the box is unchecked, it unlocks the sheet, and changes the Locked property of an adjacent cell to Unlocked. If...