![]() Set oRow = ThisDocument.Tables(1).Rows(i) Set oData = oTable.Cell(m + 1, n + 1).Rangeįor i = 2 To ThisDocument.Tables(1).Rows.Count You could populate the combobox and extract the image using the following codeĭim i As Long, j As Long, m As Long, n As Long However you cannot store graphics in a combobox so you would have to read the table again to grab the appropriate in-line graphic from the Signature column ofĪssuming a simple userform with a combobox and a pair of command buttons coded as follows This can then be used to populate a multicolumn combobox, with the first four columns of the table. You can insert the signatures in the last column You can certainly call an image file based on the selection from the combo box, or instead you could create a Word add-in template to provide the macro/userform and have the table in the body of the add-in. I might even be able to talk them into saving the detail in Access if that offers an easier solution. Would I need an ID field to uniqely identify the staff member, like a primary key in Access. ![]() Staff Name | DDI | Mobile | Email | SignatureĬould the signature be a hyperlink to path and file name? Or would the jpg/png need to be inserted in the backend file. Is it possible to access an Excel List or Word table to do this? Also the action of choosing the name would also need to choose the other related fields to that staff member. But as the list could contain about 15 names which will be changing, the client wants toīe able to maintain the list themselves in a user friendly file. I'm well used to writing UserForms in templates to do this but I have always used the UserForm initiate event to populate the combo box with a few typed in variables. Scanned signature inserted in the correct location. They wish to select a staff member from a drop down list (combo box control) and have the document signed off with the name, job title, DDI, Mobile #, Email address and additionally a ![]() I need to provide a shortcut for a client for signing off letters.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |