VBA GUI to find/edit blocks on a DWG

[js_col2367]

GOAL

At my company we update the floor plans and update blocks that identify individual cubicles containing employee ID, name, department and other few attributes. We also have kitchen, conference rooms and some others. After we have the blocks updated in the DWGs per floor, our directors and customers can see the floor plans plus we can have occupancy rates and available cubicles pero office/floor/buildings to make some important decisions on floor planning everytime we see a trend for onboarding employees.

VBA limitations

There's some limitations on VBA where it will load a limited data into a created VBA form. The GUI was created for the employees that update the floor plans so they can update the ID of the employee on the block and then another automatic process will masively update all the blocks looking at an excel for employees data like name, department etc.

QUESTION

Is someone facing the same challenge to provide a tool to easily update blocks to have the stadistics of office/floor occupancy rate?

Is there a way to go beyond VBA limits to make a better GUI for my employees?

Thank you in advanced.

[Ed__Jobe]

It sounds like you need facility management software.

Regarding your current solution, it's difficult to offer advice since its a custom solution and you haven't shared any code for us to examine. Thus I have no idea why you can only "load limited data".