PDA

View Full Version : Solved: Editing listbox in a row



white_flag
03-26-2010, 04:36 PM
Hello :)

I need your help. I try to figure out how can I edit an listbox that is filed in a row. Please look in attachment (that will explain more then my words)
I appreciate any suggestion.

thank you

lucas
03-26-2010, 05:46 PM
It would be better if insulation, type and density were column headers wouldn't it?

white_flag
03-27-2010, 12:02 AM
I know ..but will follow a lot more proprieties so it is better that the layout to be like it is now. because in the begin was like you said, but it was not good.

mdmackillop
03-27-2010, 08:34 AM
Storing data in Public Variables seems to simplify operation

white_flag
03-28-2010, 05:19 AM
thank you, mdmackillop
but wen the button ADD Insulation is fireup (make the rutine) the list box will be in the same range (colomn) not in the row. The situation becoms complex and I can not fix it alone. Can you helpp me a bit more?

mdmackillop
03-28-2010, 05:41 AM
Your code added a new insulation to the right of previous. This has not been changed. Can you clarify what you are tring to do or add it to the sample.

white_flag
03-28-2010, 05:55 AM
that is correct but after the add buttom the list box from userform take the values from A2:A7 not from A2:F2

mdmackillop
03-28-2010, 06:26 AM
There is an issue with setting a listbox row source and also populatiing it from code. I've added a dynamic range name "insulation" used to populate the list.

white_flag
03-28-2010, 08:04 AM
this is perfect ..I own you some beers :)

thank you very much