1. R

    Random value must be unique depending on date range

    Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created. I would like to have only unique random values per week, and a minimum of 2...
  2. R

    Color cells if workday and holiday (VBA)

    Hello, I got a macro button which adds month sheets for a specific year that is entered in an inputbox. The following code unsuccessfully attempts to fill all working days with a pink colour if they match a range of cells that represent the holidays (and include blank cells). Is there a way to...
  3. E

    How to add OnError vba on my current subroutine?

    I tried adding OnError on my current sub. I success adding it but it always shows the Error message even there is no error. How to add the OnError correctly? Public Sub Searcher() Dim wss As Integer wss = Application.InputBox("Please enter Sheet Number", "Sheet Select", Type:=1) With...
  4. R

    Userform listbox search button

    Hi, I have a search button in a userform to highlight/select the matching list item based on the value entered in an inputbox that is activated by this search button. I would like to be able to select the list item, regardless of case sensitivity. With the code below my entered value does not...
  5. R

    Macro to add month sheets containing days

    Hi, I have a VBA code (see below) for a macro button to add month sheets in a workbook. Now the month sheets are sorted from January to December, but I would like them to be sorted from December to January; while still keeping differently named sheets at the end of the worksheet tabs. After...
  6. S

    How to prompt an input box and add comment when certain value is selected

    Howdy y’all, I am working on a sheet that will ultimately have a lot of non-Excel-savvy folks using it. For that reason, I’ve been asked to protect the sheet to limit how much can be edited. As such, I don’t want to allow “edit objects” when protecting because there are several shapes/text...
  7. S

    Copy a column selected by input box to the next available column on an existing sheet

    Very new to VAB and I have a workbook with both values and free text survey responses. I'm trying to cut the Free Response Text columns to their own sheet in my workbook. The columns this free text will be in may vary depending on the survey data entered, so I've used the input box to allow the...
  8. T

    Using InputBox to selectively place data into the specified Row

    Hi All, I have a button that leads to a UserForm where the User enters in some information and is prompted with an InputBox. The intention is that the user types in the row that they want the aforementioned UserForm information to be placed. I seem to be struggling with transferring the row...
  9. W

    VBA - Posting Multiple Table Results in MsgBox Using an InputBox to Search [VLookup?]

    Hey everybody! I've been scouring these boards all week and have seen a pretty kind community. I'll be frank, I'm applying for a job and I have an assessment they want me to complete to the best of my abilities. It was expressly stated I could use whatever resources I could get my hands on and I...
  10. U

    VBA InputBox need user to enter details if not loop back on itself

    So I'm new to doing this !!! I have used the record Macro function and then expanded when necessary. what I need help with is having my input box require a text entry. if its blank have and error message and for it to return to the message box, if cancelled the new sheet be removed and go back...
  11. K

    inpubox userform to add and delete data in range

    hello. i have a sheet in which i record some projects, each one with a different color tag. i.e. the range C3:C21 is where the projects names are stored. I would need a macro that after pressing a button, show the items in the cells range like a list and allows me to add or delete dynamically...
  12. littlepete

    inputbox not showing value of cel to adjust and does show when in next cel and going back

    hello :) i am currently working on an inputbox to fill in new data in a new last row, and that's working perfectly ! now i'm trying to adjust the macro to go through all data of an existing row. when going from K to Z it does not show the data of the column in the active row. but when i type...
  13. J

    Input box with non contiguous range in VBA not working

    I have a macro that creates an Outlook email with a table containing data from selected ranges in Excel. However, it does not work for non-contiguous ranges. When user manually types comma or holds CTRL to select multiple ranges, it only grabs the first set of continuous range. How can I make it...
  14. Jaafar Tribak

    Standard VBA InputBox Forced Into Taking More Than 256 Characters (Up to 4280) + Other Cool Features.

    Hi all, I have been playing around with the standard vba InputBox to make it more powerful and flexible. I have named this cutomized vba InputBox as InputBox4280Chars These are the main added features : 1- Takes up to 4280 Chars. 2- InputBox size automatically adjustable depending on the...
  15. B

    How to remove "?" from input box

    I have below code where code asks for date from user but there is help (?) in the prompt box. can someone hep to find out how to remove it. strdate = Application.InputBox(Prompt:="Enter the weekending date (mm/dd/yyyy)", Title:="WEEKENDING DATE", Default:=Format(Date, "Short Date"), Type:=1)...
  16. R

    Disable AutoSave after 'Enable Content' but Before 'WorkbookOpen'

    Hi all You probably all know the AutoSave in Excel. And probably a lot will know how to disable it with VBA. Sub Workbook_Open() ActiveWorkbook.AutoSaveOn = False End If Situation: When a user is opening this file for the first time, Excel will ask to 'Enable Content' for security...
  17. D

    Excel VBA AutoFiltering using InputBox to specify the Criteria - *contains*

    Hi Folks, My goal is to be able to filter a column in a dynamic table for strings that contain non-alpha characters like #, $, etc using wildcards (*). I wish to use an InputBox to specify the special character. Something unexpected is happening: If I directly code 'Criteria1' e.g., for #...
  18. W

    Submit InputBox value a Cell

    I have the following code but needs it to submit input value into an excel cell. Sub UserForm_Activate() Dim myInputBoxVariable As Variant myInputBoxVariable = Application.inputBox(Prompt:="Enter Product", Title:="Stock-Position Request") MsgBox "Your input was: " & myInputBoxVariable End Sub...
  19. B

    InputBox and Cut and Paste based on value

    Hi, I have a problem: I need to line the same people in column B and currently it looks like this person is always in one cell from A-H but not always in column B as desired. If this person is in for example column H then I have to move him/her to column B and person from column G to column A...
  20. tomsov

    Saving excel sheet using inputbox to select date range.

    Hello, I've been working on a complicated workbook but have ran into a problem that I can't seem to solve. I need to output a list of invoices to an external application (it can be imported as an .xls file but must be in a stand alone workbook on Sheet 1 for this to work). I have so far managed...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back