input box

I have the following code would like to have the results from the input box to copied to cell B7, however it is not copying the results Can someone help. Private Sub CommandButton1_Click() 'Sub AddSheetTest() 'Replace "Sheet1" with the name of the sheet to be copied. Dim i As Integer, x As...

Hello All, I'm just getting started with VBA - trying to teach myself. I was lent a book by a colleague and that's helped a lot, but I have an issue for this particular project that I can figure out. I'm sure it's a bit complex for a first time project, but I wanted to tackle something that...

Hello, I can embed a blank document into a cell using a macro assigned to a command button. But what I want to do is by clicking on a command button embed a specific file entered in the input box in the active cell. I keep having the message run-time error '1004': Cannot insert object. Can...

I need help with the final touches on this portion of this code. I am trying to use the entry of the "LOT" to activate or select the open workbook with that entry. So if 1023987 was entered, I would want 1023987.WQ1 to activate on the desktop. I have posted a couple of my tries so far. Dim PC...

I have written a macro that uses an input box to search a column. To make it more user friendly I've added an additional column with tags in case the user doesn't input the exact verbage in the input search box. how do i get the macro to look into column 2 (B) AND column 5 (E) for it's search...

I am using Excel 2007. I want to know if what I am trying to do is possible with VBA. I'm not looking for code, but rather advice on whether it's possible or not. I may have code questions later if I run into trouble. I want to have an input box on an Excel template that asks the user to enter...

I want to allow the user to enter the name of the worksheet that they want to print with the use of an INPUT BOX. The code below works for a single worksheet; however, I want to expand the number of worksheets the user can print, and I think I want to use an array to capture the various entries...

I am trying to write some VBA in Excel 2007 to filter a list by excluding an item specified by the user in an input box, and then delete the remainder. I've done quite a bit of searching around, and have been able to figure out how to filter the list to the value in the input box, but I want...

I have a userform that reads data from several worksheets (in the same workbook as the userform). Those values represent dollar amounts and are formatted in the sheet with two decimals. I want to display them as the default entry in an input box so one can see what's already stored as the cost...

How do I hide and password protect a sheet without hardcoding the password? I've searched the forums and can't find an example where passwords are not hard-coded, hence this new thread. I have 11 sheets in my workbook, a summary sheet (visible) and 10 input sheets (xlveryhidden and require a...

is there any way to select chart via name using vba code in excel:confused:

Apologies, as I have no idea how to write in VBA. I would like to assign a macro to a check box, that when clicked, an input box comes up, I need it to gather : the date, the customer, the assembly number, and a comment. I would then like this information to be stored on the spreadsheet. I...

I am trying to get an inputbox name a shape within my workbook. This is what I have so far and i am getting a Run-time error ("The specific value is out of range") on the part in red. Any code help would be great. Dim MyInput Sheets("List Form").Select...

Need code that will open a input box and ask a user for a date and a count of users for that date. I can't install the Date picker add-in so I want the there to be some validation for the date format. Example: 01 JAN 12. I want the output's to be shown in the next empty cell in the range K8:K200...

I found this very simple code find method but I need to have it give an error message when it cannot find what was entered into the input box. The message box should have an OK button that will return back to the input box so the user can try again. Sub FindMe()...

Hi, I am currently using a very basic input box that allows the user to enter a date. I would like to restrict them to choosing only the Thursdays in the past month. Is this possible? Here is my code so far: Date = Application.InputBox("Please Enter The Appropriate Date", "Date", 0)...

I'd like to add an Input Box which will create a header cosisting of three lines of text. The three prompts for the user should be: 1. Please enter account name. 2. Please enter account number/company code. 3. Please enter time frame. Does anyone know the VBA code for this? And how can I...

Hello all, What I am searching for is how to have a user insert text using an input box into the row they just inserted via input box. An input box asks user which row to insert new row. then an input asks what text to input into that row on column 3. here is the code im using to input new...

Hello, I am working with a macro that take three input values (min, max, decimal places) and returns random numbers within those bounds to a selected area. Sub RandNums() 'http://excel.tips.net/T002077_Generating_Random_Testing_Data.html 'creates random numbers within selection 'constraints...

I have a sheet with out 4000+ products on it (item numbers & descriptions) - I would like to create a search option for the guys in the field (much like in MSWord) where you enter keyword(s) and it will highlight every instance of the word. (highlight word, cell, entire row I dont care.) :) I...