Help with R1C1 formula

**kmlloyd** · 11-05-2015, 03:44 PM

I have a UserForm that when you hit submit, it enters a bunch of values and formula into a sheet. This is one of the formulas it should be entering into the sheet. I thought I had this right but I'm not getting it to work....I want it to look at the cell 2 to the left, and if it says "See Notes" then I want it to return "See Notes" otherwise, I want it to return the Month value of that cell.

The cell will either contain a date in MM/DD/YYYY format, or it will contain "See notes"

I'm really new to R1C1 and VBA and I'm having a heck of a time

Please Login or Register  to view this content.

**GeneralDisarray** · 11-05-2015, 03:52 PM

Please Login or Register  to view this content.

From your description, I'm not sure why you are using the isnumber() or the search(). It can be tricky to get the quotation marks into the string. You need to add them in with the & """" & - Basically, type out the formula as you would in the worksheet. Then, replace each double-quote mark with & """" &.

That should do what you asked (look 2 cells to the left, return "see notes" if that is what is found, otherwise return the month).