ret

I've been struggling with trying to have a msgbox that is prompting other msgbox's. and a yes equaling two separate msgbox's. if it were to look like a tree I would draw it to look like this: New Yes/No; ____no=endsub ____1yes= New XXX Yes/no; ________________no=XXX (sheet not visible)...

Hei, I would like to make a macro that searches the whole workbook for errors(#Value, #DIV/0, #Error etc.) and returns a cell either green (colour 5287936) if no errors found. or red(colour 255) if errors are found in workbook. to make it easy I want to search for "#" as I do not have "#"...

On to the next problem... I'm working with several workbooks moving information back and forth and I would like to know how to check if one of the workbooks I'm working with is already open - I've Googled the heck out of this and - nothing I found works. Below is the closest idea to what I'm...

Hi Guys, I'm using the below function which turns a week number into a week Public Function Week2Date(WeekNo As Long) As Date Dim Jan1 As Date Dim Sub1 As Boolean Dim Ret As Date Jan1 = DateSerial(Year(Date), 1, 1) 'Sub1 =...

I am struggling with VBA to only display a message box when one cell is altered. What I have works but then if any other cell changes the msgbox continues to prompt the user. please help, this is tool I built for many users and I only want the msgbox to appear when B12 on sheet 1 has anything in...