protegeone
10-21-2005, 07:24 AM
Hi Everyone,
I'm even more at loss with userforms then with VBA, so your utmost patince please.
What I'm trying to achive is
Please see my attachment ( to get more sense out of what I'm about )
Taking "Senior Supervisor" wsheet, Userform is called by button in cell ( e.g. L6 ), having 2 comboboxes.
After selecting choices from both boxes ( should choose from both at all times )
the following formula should be run in userform
IF(ComboBox1<=0;0;M3/Combobox1*(Combobox1-Combobox2))
result then should be copied to cell M6.
(Due to being merged cells in other macro I've only been able to copy to it calling it range. e.g. M3 as M3:N5 or taking destination cell M6 as M6:N7, but this might be only me, absolute beginner )
To complicate it even further as I would have 3 buttons in all calling this userform, the question is is there a way to have userform first checking downward whether destination cell is empty or not and only copying result to the next empty cell from the available three, instead of making 3 identical userforms with only changing destination cell address.
Hope someone out there would be able to get some meaning out of this and would help.
Thanks
Protege
I'm even more at loss with userforms then with VBA, so your utmost patince please.
What I'm trying to achive is
Please see my attachment ( to get more sense out of what I'm about )
Taking "Senior Supervisor" wsheet, Userform is called by button in cell ( e.g. L6 ), having 2 comboboxes.
After selecting choices from both boxes ( should choose from both at all times )
the following formula should be run in userform
IF(ComboBox1<=0;0;M3/Combobox1*(Combobox1-Combobox2))
result then should be copied to cell M6.
(Due to being merged cells in other macro I've only been able to copy to it calling it range. e.g. M3 as M3:N5 or taking destination cell M6 as M6:N7, but this might be only me, absolute beginner )
To complicate it even further as I would have 3 buttons in all calling this userform, the question is is there a way to have userform first checking downward whether destination cell is empty or not and only copying result to the next empty cell from the available three, instead of making 3 identical userforms with only changing destination cell address.
Hope someone out there would be able to get some meaning out of this and would help.
Thanks
Protege