Posted to microsoft.public.excel.programming

SDH

external usenet poster

Posts: 19

lisbox reference and calculation

I have a lisbox(lboProduct) on a userform (UserForm3). The listbox references
a list of products on a worksheet (Sheet1) in column A. In column B of Sheet1
is the corresponding price of each product. The UserForm3 also has a TextBox
(txtQuantity). I have a command button (cmdCost) that when clicked needs to
show the total cost. Which is equal to the amount entered in txtQuantity *
the corresponding price of the product selected in the lboProducts.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LisBox Column Width	Abdul[_2_]	Excel Programming	4	April 4th 06 07:16 AM
Can you do calculation for Row or Column for link reference first?	KhaVu	Excel Worksheet Functions	1	December 27th 05 08:57 PM
Cell reference based on calculation	scott_ross_3	Excel Discussion (Misc queries)	3	October 14th 05 08:24 AM
Horizontal Scrollbar For Lisbox	Justin Starnes[_2_]	Excel Programming	5	October 20th 04 11:26 AM
LisBox List	Abdul[_4_]	Excel Programming	2	October 8th 03 05:08 PM

All times are GMT +1. The time now is 02:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us