Forum Discussion
Solved
VBA - Different custom fields used depending upon schedule
Hello, I'm pretty sure the answer is that this can't be done but I thought I would ask in case someone smarter than me has a way. Is it possible to set a variable that refers to a field and use ...
- I recall doing something like this in the past but I'd have to do some digging to see how I might have done it, or maybe I'm just remembering wrong.
However, there are other options. One is to detect the user (e.g. Application.UserName) and use that as a branch to appropriate lines of code. Another is to do a find and "replace all" in the code. But I believe the best option is to develop a consistent set of custom fields and then train the PMs to use those. It really makes things a lot smoother for everybody.
John
I recall doing something like this in the past but I'd have to do some digging to see how I might have done it, or maybe I'm just remembering wrong.
However, there are other options. One is to detect the user (e.g. Application.UserName) and use that as a branch to appropriate lines of code. Another is to do a find and "replace all" in the code. But I believe the best option is to develop a consistent set of custom fields and then train the PMs to use those. It really makes things a lot smoother for everybody.
John
However, there are other options. One is to detect the user (e.g. Application.UserName) and use that as a branch to appropriate lines of code. Another is to do a find and "replace all" in the code. But I believe the best option is to develop a consistent set of custom fields and then train the PMs to use those. It really makes things a lot smoother for everybody.
John