I have an Excel file here that contains a UserForm object containing multiple textboxes and comboboxes that I would like to auto-fill with data from MS Access if I can. Specifically, when I'm viewing a particular record within an Access form, I'd like to click a button that launches the Excel application/workbook and references specific textbox and combobox items on the UserForm, populating them with values from that particular database record currently being viewed in MS Access.
From with Excel VBA, I can currently do this with the following code.
UserForm1.TextBox1 = "This is test data."
Just trying to get from MS Access to MS Excel.
Is this possible? Any help or suggestions would be appreciated!