The_Taffinch
New Member
- Joined
- Mar 16, 2009
- Messages
- 5
Hi all,
Wonder if someone cvan point in the right direction.
I ma wanting to create a sheet where the user can add items to a quote/list using by selecting items from a drop down list. I have set up a combo box to output a value based on items from a pre-set list but I am struggling to work out the ouptut side of things.
I would think it is a case of incrementing the LinkedCell property of the combo box somehow so that the output is generated to successive lines...but I can't work out how to do this. I have tried using an INDIRECT expression to increment the row ref in the combo properties but Excel won't accept this. I think it wants a straight reference.
Any ideas? I have only very basic VBA skills so any 'scripting'-based answers would have to be written for dummies!
Wonder if someone cvan point in the right direction.
I ma wanting to create a sheet where the user can add items to a quote/list using by selecting items from a drop down list. I have set up a combo box to output a value based on items from a pre-set list but I am struggling to work out the ouptut side of things.
I would think it is a case of incrementing the LinkedCell property of the combo box somehow so that the output is generated to successive lines...but I can't work out how to do this. I have tried using an INDIRECT expression to increment the row ref in the combo properties but Excel won't accept this. I think it wants a straight reference.
Any ideas? I have only very basic VBA skills so any 'scripting'-based answers would have to be written for dummies!