![]() |
|
#1
|
||||
|
||||
![]()
Methinks the code has been tampered with.
If Me.RevisedTotalDropDown throws an error then I can tell that Me doesn't contain a control called RevisedTotalDropDown. Your subroutine is called Document_Open which implies it runs automatically when a document is opened. I note that this code is not opening a userform. However, your code includes Me.controlname items which are used inside a UserForm module and the 'Me' refers to the userform itself. I would have expected your userform code to sit inside a macro named UserForm_Initialize and it would then run after the userform has been shown.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
![]() |
Tags |
data member, drop down lists, methods |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
RHODIUM | Word | 6 | 10-01-2016 04:43 PM |
![]() |
TzarChasm | Word | 7 | 04-14-2016 06:28 PM |
creating a code to create dynamic text in word | ah8471 | Word VBA | 1 | 12-29-2015 10:52 PM |
![]() |
DeadBatteries | Word | 1 | 08-24-2012 09:09 AM |
![]() |
dmncs | Word VBA | 1 | 05-06-2012 09:29 PM |