VBA Beginer -Real Estate Industry

[Big Boss]

Hi,
I am beginner in VBA,
I am currently working in the assets management and investment department for a mega project to develop public assets (Museums, Parks, Venues…etc.), and several real estate assets classes (Residential, Retail, Offices, and Hospitality, healthcare, and education).
Currently, we are working on developing a consolidated financial model for all the assets within the park and one of the outcomes of this model is to provide us with the potential lands value per plot (parcel), based on a discounted project cashflow.
One of the key outcomes of this model is to provide us with a prefeasibility and a potential land value (sqm price) that can be used as a threshold before going into a partnership with investors (Jv, SPV, …) so that we can have an estimate of our share (land-in-kind) on any JV.
Since the model needs to be updated frequently, what are the best-VBA-practices that can facilitate and help us in the process of updating the key assumptions (E.g., CAPEX costs per sqm for construction, design, land scaping, infra structure, ...etc.).?
I know this is seems very general, however, I am expecting at this stage to receive ideas and thoughts from those working in the industry and who might had faced such a challenge (updating the model).
This will help me a lot in approaching this challenge and establishing necessary requirements and data bases to activate relevant MACROS moving forward.
What I define as success here is when we reach a point where whenever we open the model and run one macro, all model outcomes are based on most recent assumptions.

Thank you for your time.

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=SIDLFRkUEIo&lc=UgzTF5vvB67Zbfs9qvx4AaABAg
https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxLtKj969oiIu7zNb94AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=Ugx12mI-a39T41NaZ8F4AaABAg.9iDQqIP56NV9iFD0AkeeJG
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzFkoI0n_BxwnwVMcZ4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg.9htChVuaX9W9htG01cKBzX
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htJ6TpIOXR
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwMKwGZpDjv7vi7pCx4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htOKs4jh3M
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgxVW-am20rQ5GFuJ9F4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[DocAElstein]

Hi Big Boss
Welcome to ExcelFox
You are very welcome to post these general questions here, but you may not get a large audience just now, as just me and a few others pass here by from time to time. ( My interest in Excel is purely as an Excel hobbyist, answering questions, mostly writing VBA, for fun, so I have no computer or software related work experience and therefore have little experience of actual applications).

Feel free to post in parallel to other forums where you may reach a larger number of professionals with the experience to help you.
Some other forums may have an extra sub forum for off topic or general questions or general discussions.

Here are some example forums that I know about: These general discussion sub forums are at two of the main Excel forums:
https://www.mrexcel.com/board/forums...plications.22/
https://www.excelforum.com/the-water-cooler/

Note that most forums have a “cross posting rule”. Basically it means they are happy for you to post your questions in other forums as long as you tell them , preferably with a URL link, of the other forums where you posted the same question.

Alan

---

P.s.
You may experience problems posting a link at some forums as a new member because anti spam measures often block links from new members. At some forums you can fool that by disguising the link somehow.
One example I know about: For example the link you would need to advise people of your post here at excel fox would be

https://excelfox.com/forum/showthread.php/2763-VBA-Beginer-Real-Estate-Industry

If that gives you problems when you try to post it, and if the forum supports BB code tags, which many do, then you could try to post this instead

h[color=Black]t[/color]tp[color=Black]s[/color]:/[color=Black]/[/color]excelfox[color=Black].c[/color]om/forum/showthread.php/2763-VBA-Beginer-Real-Estate-Industry

What you are doing there is using the BB code tags to color some characters black. By default all characters are usually black anyway, so it wont make any difference to what is finally posted. You should just get this posted, as before:

https://excelfox.com/forum/showthread.php/2763-VBA-Beginer-Real-Estate-Industry

But you will have fooled the software that looks for URL links, as you have messed up the character combination bits that are checked for: It appears to do the checks on what you try to post and it does not usually check what actually appears in the final post

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=SIDLFRkUEIo&lc=UgzTF5vvB67Zbfs9qvx4AaABAg
https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgxLtKj969oiIu7zNb94AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=Ugx12mI-a39T41NaZ8F4AaABAg.9iDQqIP56NV9iFD0AkeeJG
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
https://www.youtube.com/watch?v=tPRv-ATUBe4&lc=UgzFkoI0n_BxwnwVMcZ4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg.9htChVuaX9W9htG01cKBzX
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htJ6TpIOXR
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwMKwGZpDjv7vi7pCx4AaABAg
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg. 9ht16tzryC49htOKs4jh3M
https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgxVW-am20rQ5GFuJ9F4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA