How do I create a form that allows the selection of a range of cells that I can perform a calculation like multiplying all the cells together?
Included in the form is also a combo box. This combo box have 2 selection on the different types of output. For example, % or decimal points.
Does anyone have any idea how to create this form to perform the calculation.
Hi,
You can select a range with an UserForm with RefRdit control:Originally Posted by laureenl
http://support.microsoft.com/kb/213776/
Alternatively, use a modeless UserForm, so you will be able to select a range any time you like, and then perform the calculations by reading the value of each cell in Selection.
MS Excel Games Library and much more:
http://www.dzikosoft.com/gmexcel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks