input boxes

hello. I have inherited the below code, which works great but, ideally i would like the code to ask the user ´which column header to sort the table by´..... which the user can either type manually or, if possible select from a list? you will notice i have made the bit below, that i would like...

I have user forms and trying to get them to work one after another. The issue is the first one is still active while second one shows up. The data entered but form still there. I tried hide and unload but then my data went away. Any help is appreciated. Here is current code from a NOVICE. First...

I have tried unsuccessfully to achieve this Display Input box "Please enter a reason" If the X or Cancel is pressed the the routine ends If OK is pressed and the input contains nothing, then display a message "Reason is required" I cant seem to get this combination to work correctly Sub...

Hi Guys, I have some code that copies some columns of data based on the text typed into an input box. Code below is working great. What I would like to achieve if possible is 2 more input boxes asking for the destination workbook name and also the sheet name within the destination workbook...

Hello, I have googled a bunch and I find how to make inputbox promts and that part of my vba works. But now I want to use that info collected from input boxes and insert that into my formulas to paste in various cells on a sheet. here is a short version of what I have once i get one working i...

Hello all, I'm trying to find out how to add a record to an Access table called 'work_list' with the database 'data.accdb' using VBA from Excel that displays Input Boxes to collect the required information. Once I have this working I will eventually change it to a userform to collect the data...

With my code below you can see I set up a very non-secure means of executing certain commands based on the user names that are inputted. As you can see, it's not very dynamic at all. I'd like to modify it to pull from a range of cells A2:A20 in worksheet "UserNames". Any suggestions on how to...

Hello, I would like to create a macro to find and replace parts of my model with data that the user chooses with input boxes. i have used this method before and it works well, there is just a missing link between the Input Box and Replace function Sorry if my formatting is not perfected this...

Hello, i have created a programm that asks for an input Column and then creates an average of the 60 values and then next 60 values and so on. I want that insteas of input of Column(A,B) I will input the variable with which the column have been named , like the column L have been named as Power...

HI! I've searched and experiemented, but I can NOT get <acronym>VBA</acronym> to post sequential message box values into a spreadsheet. What I'm trying to do is to loop through, e.g. spreadsheet cell (1,2) = textbox1.value; spreadsheet cell (2,2) = textbox2.value; etc. Following some advice...

I have a macro that compares two sheets (in a workbook that might contain 10 sheets). Currently, the user enters the names of the two sheets in two input boxes. Is there a way that the user need only to click on a sheet tab and the sheet names are used in the macro? (this would eliminate any...

I think I kind of have a basic feel of what needs to be done, but am not getting it to work. I need to look up a part number and PO number on tab one, and match it to the part and po columns in the table on tab 2, returning the value pieces shipped, from the table from tab 2. I have been using...

I am using the below code to search a column of data and I am getting an error when I enter a value that contains both numbers and letters (ex. 88006E) but does not cause an issue when using just numbers (ex. 880066). If I step through the process the error happens right after I enter the value...

Hi. I need my Input Box data to fill in on one row and then the next time they run fill in the next row, etc. My problem is that the starting ranges are locked in, so even though it goes to the first cell of the next row after enter, the input data after the first cell go right back to the...