Range("FieldEmail").Value = Me.txtEmailField.Text 'Values written to sheet for use in UDFToken and UDFGetGAAcctData array formulas 'with a unique list of accounts, which will in turn populate the Profile combobox with the profiles associated with the chosen 'Obtain API Token from Google Analytics (GA), indicate to user that token has been obtained and populate Account combobox I'll paste all code and highlight the offending snippet(s) below: Private Sub btnGetGAToken_Click() When I call a module sub-routine via a command button, the values don't appear and I've no idea why. When I run the form, the values appear as intended. ![]() ![]() ![]() The title should give a fair overview of the problem but I'm running a dynamic named range for use in a combo box in a userform.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |