Search results for query: *

I'm trying to write some code to select a case based on an interval of time. For example, if the value in the cell is between 8:00 and 8:59, I want it to shade a certain color. However VBA does not like time formats in the case statement, at least the way I'm writing it. Case 8:00:00 To 8:59:00...

Hi, I see there's someone having a similar problem in the thread down below, but unfortunately it's not helping me figure out what's going on with my code. I'm trying to conditionally format cells based on input values. I keep getting an object code required error when I run the following code...

I'm trying to expand on some code written by a previous person. I'm trying to have the macro identify up a defined date variable (uRepsonse)from 3 different spreadsheets. It works fine on the first sheet (this was the original code). I tried to copy the code for the 2nd and 3rd sheets, but on...

I'm trying to program a macro to pick up a variable range of data and copy it. I'm doing this by having the macro find the date in the workbook and pulling the data adjacent to that date cell. The copying part is not the problem, it's how to define a range of data without specific cell...

Hi, Some time ago, someone helped me with the following code. What I am trying to do is find a cell based on a date given (uResponse), and then importing data from another sheet adjacent to that cell. This code works just fine. However, now I want to do this to more than 1 sheet, and I'm having...

Hi, I've created a macro to ask for a value (via msg box), then find the value in a worksheet and then it brings in the data on the same row as that value. I now need to modify it because the response will be in multiple sheets, so I need it to find the response in sheet 1, then do it's thing...

I'm new to VBA programming, and I'm having trouble with getting the input box to close when the cancel button is clicked. If anyone has any suggestions, it would be much appreciated. Thanks, Garrett Message = "Input the date which you want to update. The format must be YYYYMMDD." TitleBarTxt...

I'm trying to write some code that will find a value in a workbook. I'm using cells.find code, but it only works when I'm on the appropriate sheet before I run the code. Any help would be appreciated. Thanks, Garrett

I'm learning VBA on my own, so excuse my lack of expertise. I'm trying to have message box pop up until a valid date is entered that will bring up file with that date in the name. And I want the message box to keep coming up until the user does input a valid date. Currently this code works if I...