prompt user

I need to setup code that compares 3 columns. column C will have comparison values. I am trying to compare column C to D. If column D value is matching C, column F should be greater than 1. If not I would like to prompt user "Please put greater value in column F" and exit out of the code. Is...

Greetings everyone, I have a macro that fills a spreadsheet with data from a number of text files. Currently the macro uses a hard-coded name to open the files, but I've made some changes so that the files now have the date added to the front of the file name. For example, one of the files...

Hello everyone. :) Is anyone knows how to automatically replace part of a formula, which is a link on that formula? Right now, I'm trying to create a macro that would enable me to replace a link on a formula. The formula is shown below...

Hello, I would like to create a box that pops-up and prompts the user with an error message: "Return value is invalid. Please click 'OK' to correct." when a conditionally formatted cell returns an out of tolerance deviation (computed from a three-set data entry). How can this be done? Thank...

I have a worksheet which contains formulas and validations in Row 5. If a user needs to insert rows, I'd like to prompt them to ask them "how many rows would you like to insert?" and then insert the requested number of rows below Row 5. I would then like to copy all of Row 5 and paste into the...