Re: VBA CODE for Excel 2007 & 2010
To get "days listed" you would need for me to create a new column and put in the date each property was listed for sale? I'll start working on that today.
VBA CODE for Excel 2007 & 2010
-
-
Re: VBA CODE for Excel 2007 & 2010
Yep, if you can post that after you're done I'll fix the code to suit. Some remote column...for all I care it can be in column XFD, lol...doesn't matter, but if it's way over there it will make your scroll bar very tiny.
But you get the idea...the column can be hidden/zero width or formatted with white text or however you want to hide them.
After the current properties are "dated" with the starting date, the rest after that can be automatic and the "days listed" can be a simple:
=Now() - that date
Anyhow, I ramble, lol....if you can make a column with starting dates...a column that will never be overwritten...I can fix ya up.
-
Re: VBA CODE for Excel 2007 & 2010
Also, something else to think about...
Do you want the user to continue using "days added" on the userform, or switch to "DATE added"?
makes little difference in the coding, it's just as well either way.
-
-
Re: VBA CODE for Excel 2007 & 2010
QuoteI would like for their to be a column for "Days Listed" (# of day listed) I am creating a column for the actual date they are put on market. We could add in a block for the new property entry that says "Date Listed" It would need to except the .... *mm/dd/yyyy format so it can update right?
It will accept the date format. No problem.
QuoteGood call on that lol... also I would like to add another block on the user form for adding new property that has "MLS#" and the column to be column E but I hope it is easy to change the codes to still work.
It won't be too bad, lol.
-
Re: VBA CODE for Excel 2007 & 2010
Armyguy297...did I read right that you’re in Afghanistan right now? If so, you take care of yourself out there brother. Come home safe.
Bryce (USMC)
-
Re: VBA CODE for Excel 2007 & 2010
Yea I am a contractor so I cannot take credit... been here as infantry before so your comment is appreciated... but they get the credit now... Thanks for the kind words... I see you are USMC... Thanks for your service as well... although, generaly speaking army and marines have our rivalries lol...
-
-
Re: VBA CODE for Excel 2007 & 2010
No questions that I can think of. Next thing I need is the updated "Sheet1" with the new "date listed" column.
-
Re: VBA CODE for Excel 2007 & 2010
Haha, those rivalries only exist in Garrison...in war, were the same.
-
-
Re: VBA CODE for Excel 2007 & 2010
Good Macro.
-
Re: VBA CODE for Excel 2007 & 2010
Ok my friend, here's the latest...
-I took a few more liberties with the toolbox, lol. "Delete one entry on sheet 2"..."clear all entries on sheet 2". If you never use it, that's ok...but it's there.
-The date listed from the userform posts into column AT...MLS into column E.
-The last 3 entries on sheet1 need to be checked. It looks like they were added with the old code, with the old column references. Not sure, just check it out.
-I had to insert columns into sheet 2 so the sheets would match or the copy wouldn't work right.
-The entry boxes on the "add new" userform section now have a few parameters set. For instance, if you enter a 6 digit zip code, or an 8 digit MLS# by mistake, it will (should) kick it out. Non numeric price fields will kick out. State codes greater than 2 characters will kick out. If you want to be able to use 9 digit zip codes it can be changed to that...or to accept either. MLS#'s are always 7 digits right?
- "Days listed" in column.........well whatever column it is, lol....will update automatically daily based on the date in column AT.
I had to split it into 2 workbooks...it appears we've reached the limit of attachments on this site. Be sure to move sheet2 back into the "......UPDATED AGAIN5" workbook, not the other way around. The coding is NOT in the "........sheet2" workbook. Again, when you're done both sheets should be in the workbook called "....UPDATED AGAIN5".
I think that's it. See what ya think and if you need changes, let me know.
forum.ozgrid.com/index.php?attachment/44912/
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!