inputboxwhat

  1. S

    For loop through array

    I'm trying to replicate what this code does... Sub Workbook_Open() 'unprotect sheet, start with all cells locked ActiveSheet.Unprotect ActiveSheet.UsedRange.Locked = True 'define variables Dim InspNo As String Dim DateRecd As String Dim QtyRecd As String Dim PurchNo As String Dim SampSize As...
  2. G

    Macro to add data to a table based on questions

    Hello, So far I have this but I can not get it use the next line inside of a table. It always uses the next row after the end of the table. Any thoughts? strName = InputBox("What is the Estimate #") strName1 = InputBox("What is the Prospects Name?") strName2 = InputBox("What is the Prospects...
  3. J

    Multiple data input message boxes at Workbook_Open problem

    Hi, we're having an issue with a workbook_open sub. We want to prompt the user for multiple inputs via message boxes, if the cell that will contain their input is blank at workbook_Open. So, we want the message boxes to continue until we've asked the user for each cell's data that we need...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top