klaushgd
02-18-2013, 03:44 AM
Hi all,
I have seen the problem I am looking for in the forum 'Populate a UserForm Listbox in Word From Data in an Excel File', however - this is just doing part of my problem and I have not been able to locate any other solutions that covers my issue:)
My issue is as follow:
I have a word templat that gives a popup when started for the user to fill out. At pressent this is okay, but it is hard to maintain. So what I want is to be able to add all needed information in Excel - since our tools have the posebillety to export my needed info to this.
The attached 'Input TR' is a short example. This info I want in the popup macro in word. When choosing name - I want Excel to give me the chooices insted of haveing it in the coded macro. After I have choosen the name - I want the product belonging for this name in the 'Product/Service:' combo box, e.g Test 1 will give the value 1...5. (I will only be able to choose one of them)
Today - everything is coded in the macro, and thus difficult to maintain.
Can anyone help me?
`klaus
I have seen the problem I am looking for in the forum 'Populate a UserForm Listbox in Word From Data in an Excel File', however - this is just doing part of my problem and I have not been able to locate any other solutions that covers my issue:)
My issue is as follow:
I have a word templat that gives a popup when started for the user to fill out. At pressent this is okay, but it is hard to maintain. So what I want is to be able to add all needed information in Excel - since our tools have the posebillety to export my needed info to this.
The attached 'Input TR' is a short example. This info I want in the popup macro in word. When choosing name - I want Excel to give me the chooices insted of haveing it in the coded macro. After I have choosen the name - I want the product belonging for this name in the 'Product/Service:' combo box, e.g Test 1 will give the value 1...5. (I will only be able to choose one of them)
Today - everything is coded in the macro, and thus difficult to maintain.
Can anyone help me?
`klaus