View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Soniya Soniya is offline
external usenet poster
 
Posts: 48
Default Add Selected Items

Hi all,


I have Rec_No in my column A and amount in Column B

something like

Rec_No Amount
1 50
2 25
4 35
8 200
10 100
11 15
12 20

I want the user to select From and To rec no and add only
items between those nmbers including start and end no.

If I use a UserForm with Two text boxes users can enter
start receipt and end receipt no. But How can I select
those items only and sum that selection and dispaly the
result in the user form?


TIA
soniya