BC_Seattle
Registered User.
- Local time
- Today, 01:48
- Joined
- Jun 18, 2019
- Messages
- 24
Ok that makes it easier on me just wanted to make sure it wouldn't be an issue if they didnt rename. Thank you so much for the help.
UnSure how to get New Comment (Blank) to the Top (1 Viewer)
- Thread starter BC_Seattle
- Start date
- Local time
- Today, 09:48
- Joined
- Jul 9, 2003
- Messages
- 16,271
I used to encourage people to convert their macros to VBA, however there are some inconsistencies in the conversion process. So I would advise against it now.
One problem is the Tempvars, they don't convert properly.
The issue I noticed was that trying to assign the value from a control to a Tempvar failed because the Tempvar thought that the control was a control.
The solution was to explicitly add ".value" to the end of the name of the control (usually a textbox) to make sure that the Tempvar was assigned the value from the textbox and not assigned the actual object "textbox" ...
Sent from my Pixel 3a using Tapatalk
One problem is the Tempvars, they don't convert properly.
The issue I noticed was that trying to assign the value from a control to a Tempvar failed because the Tempvar thought that the control was a control.
The solution was to explicitly add ".value" to the end of the name of the control (usually a textbox) to make sure that the Tempvar was assigned the value from the textbox and not assigned the actual object "textbox" ...
Sent from my Pixel 3a using Tapatalk
