box

Hello, I have looked around and could not find any VBA that would work for what I am trying to do, which seemed like it should be simpler than it is turning out to be. I want to automatically hide and unhide some rows based on the following: I have a summary sheet (in "Sheet 1") that summarizes...

Okay, I create a combo box in my form, to work with a query below. It is supposed to search for two columns in the query. It works at first. Then, I change the combo box to sort ascending and then it goes bonkers.. When I click on a name/area (my two fields) it will find the name but a...

Hi, need help on how to use Excel to meet below requirement. Below sample is just small population of total seatings so would need to automate. Appreciate your help please, thank you!!! =) Requirements: 1. Allocate the Box capacity following the Position hierarchy, such that "Head" starts to...

is there anyway to have a selection list to choose from instead of writing a comment in the comment box? Here is what I would like to do: If any cell in range H7:H37 , J7:J37, L7:L37 (which are populated by a validation list) is less than 5, then a comment box would pop up offering the...

HI is it possible to see the number/amount in words if we hover mouse cursor on a number in excel as a comment not in any cell, it will show as a comment box and when we move the cursor from the number the comment should vanish thanks dinesh saha 9932022569

I have a userform that the user will pick from the combo box list and then enter in a value in a textbox 1. Once the user clicks the OK command button I would like it to search the combo box value in column A on Sheet1 and place the value from textbox 1 in the next available row below in column...

I have a userform that has a combo box (cboEmployee). This combo box is a drop down list of employees the user will pick from. Then there's a text box (Textbox1) the user will enter data in. There are 5 tabs representing each day of the week (Monday...Tuesday...Wednesday an so on). Each day...

I have two worksheets in my workbook. Sheet1 contains customer order information with column A holding their account number. Sheet2 contains customers name & address information with column A also holding their account number. I need VBA code to start at cell A2 of sheet1 and check the account...

Hi All, Need a help on resolving the below scenario. I have a column A with Months and Column B with unique products ID's. Each months are having checkbox and i need based on the check box selection, the text box and excel sheet should be updated with the all the products from that specific...

I am trying to put the following formula in a text box ="Total: " & Data!B8 But I keep getting the following error: "The formula is missing a range reference or a defined name." Could anyone tell me what I am missing? I thought this was pretty straight forward..... Thank you Carla

I'm trying to figure out the best approach for this task; - user selects yes or no from a dropdown (or a check box would be nicer visually) - if user selects no, nothing happens - if user selects yes, a further 4 "questions" need answering, the possible answers should be from dropdowns not...

Hello guys, I've created a dropdownlist with company names. With each selection, I got a different calculation for key figures like sales, turnover ratio, Roi and so on. But now, each company got a unique company code (5 digit number). So my question, Is it possible to create a search box...

Hi All, I am attempting to create an archiving system for work and having some trouble finding a way to do a certain thing because I'm not sure how to word it for the searches... So, we have an archiving system, which is a 9 x 9 box for samples (81 samples); on the worksheet so far i have a...

Hi, I have a combo box in cell B2 with a list of names. Is there a Vba code to loop through the list, update the sheet from the combo box and print the worksheet. I have over 100 names in the list and would like to run though the list updating the sheets and printing all. Thanks

Dear I have an user form i want to mandatory text box (No. 3) please help Private Sub TextBox1_Change()[W11] = Me.TextBox1.Value End Sub Private Sub TextBox2_Change() [W12] = Me.TextBox2.Value End Sub Private Sub TextBox3_Change() [W13] = Me.TextBox3.Value End Sub Private Sub...

I am using Bound Column 1 - which works fine, but if I want the Combo Box to use Column 3 to filter the form, it doesn't do anything?

I have a Combo Box with (3) Fields: SELECT [GP Schedule].[EVM/VM], [GP Schedule].BEID, [GP Schedule].BusinessEntityName FROM [GP Schedule] WHERE ((([GP Schedule].[EVM/VM]) Is Not Null)) ORDER BY [GP Schedule].[EVM/VM]; I have it setup and bound to Column 2 - which is the BEID. When I select...

Good evening, Can some one please guide me, am stuck with the adding and updating of the list box... My userform contains a list box which is populated by a range from a current worksheet ie the last worksheet of the book, I need only three columns to be shown in the list box, column"Q", "R" and...

Hello I need vba code to check a range of cells for value greater than zero. Ive set the range = colval If there is no value in the range greater than zero I want a message box "No Value > 0" Thanks for any help

I have a spreadsheet that will have x number of lines added to it. When all lines have been added, I have a button that inserts a signature 5 lines below the lowest part. The lowest part is a line at the bottom. Underneath the line, there is a textbox that will have notes written in it...