box

I am looking for code that would look at a column, and if the cell is greater than "0" it would recheck the check box when the form is opened.any help would be appreciated.

I have a user form that include a check box. If you check the box it runs formulas and puts data in a different column than if it isn't checked. When I open the user form if there is data on the sheet it pulls it in to the user form, and you can modify as needed, however it does not recheck the...

I have a user form that I would like to modify the code on, It has a list box that pulls up a part#, then it has a text box for the cost of that part. In the text box I would like to do a vlookup that refers to the list box and pulls in the cost from a table. Currently the text box has this...

Good day all, I have a userform with a frame (Frame1) consisting a vertical scroll bar of height set to 1000 , the Frame houses 160 textboxes arranged in 40 rows and 4 columns. The 40 textboxes on the first column each have a list box. The problem is when I double click on the list box...

I have a comment box that displays in a very bad position on my Excel 2016 Spreadsheet. Even when I move it under the Edit Comment Function, when I hover over the cell, it still displays in the the comment box in the original position. Is there anyway I can lock the comment box in the location...

I am sorting worksheet by 2 columns alphabetically then filtering by a 3rd which is required to be “Yes”. Works fine on worksheet but list box on user form returns all records regardless of 3rd column - could be blank or ‘No’. Userform containing List box is based on sorted and filtered...

Good Morning all a few years ago in an old job some one helped me create this piece of code which adds a comment box once someone adds anything to a cell i'm getting a run time error can you please help thank you Jason error: Target.Comment.Shape.TextFrame.Characters(1...

Hi hope youcan help me please, I have attached the file below which I am stuck on, I havea user form ‘enter expenses’ but when I try to enter number/letter combinationin the boxes for Airfare, accommodation, ground transport and food and drink,the box goes red when I click on update and it...

I need help figuring out how to select multiple dropdown box options, without repetition.

Hello, I'm trying to find out how to display only the Nth result in a query. I have a query currently that shows all Categories of question types possible, assigns a random integer and limits the results to the top 5. On my form I want to display each of those results in a separate box. The...

When a command button opens a user form, the combo box in the user form has a blinking cursor right away. I would like the combo box to not be selected when it is first opened. Any ideas for lines of code?

I'm using a microsoft surface pro 2 with windows 10 and would like to have the onscreen keyboard show when I tap my combo box in my program's user form. Any ideas? I have found a few forums with similar questions but I still get errors.

I’m trying to use a msgbox to provide instructions if validation criteria are violated. I’m able to get the validation configured, but I would like a different message box to appear when the entered data is outside the validation criteria. For example, the validation criteria require the...

I am wanting a text box to appear if the user moves the mouse over a certain cell (E18) on my worksheet, and then I want that text box to disappear after 5 seconds. I found a blog post that talked about how to do the first part of this...

Hi all, I'm really struggling to find a vba solution here. All I want is a msg box to pop up if my table has duplicate rows. e.g. <tbody> Col 1 Col 2 Col 3 a x ee b s rr d z sg a x ee k l aa a r aa </tbody> Since row 2 & 5 are dups, I would want the msg box. Many thanks James

My apologies as i have not used userforms much. I have a userform and i am trying to total textboxes 1-18 in textbox 19, automatically: I have the following code: Public Sub recalculatetotal() 'calculates total score in textbox 19 Dim Tot As Double On Error Resume Next Tot = Tot +...

Hi, I want a box to pop up when a worksheet is activated to alert the user to delete the sheet if they are not using it. So far I have: Private Sub Worksheet_Activate() MsgBox "Not using Census Data? Delete this tab!", vbInformation + vbOKOnly, "WARNING" End Sub I'm feeling a bit stupid -...

Hi, I have a data entry text box in a form called Issue_or_Turnover. I am running a macro that opens an append query based on the text inputted into box Work_Order. At the end of the macro I want the cursor to go back to text box Work_Order. I have tried many different versions of the...

Wondering if anyone can help. I want to create a user form with two active x text boxes. In box one you put a number and the second box uses a formula to change the number and display the result. For example put 2 in box one and it shows 100 in box 2. There are many other boxes on the form but...

Hi. The below VBA is part of a code to create a text box and populate with content from two cells however I’m looking to alter to include: The cell V9, contains a number 0.5, and the cell is formatted as a percent, 50%. I need the above code to present as a percent in the text box rather than...