Thread
:
UNABLE TO PUT THE SUM FORMULA IN VISUAL BASIC
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
UNABLE TO PUT THE SUM FORMULA IN VISUAL BASIC
And, PLEASE, do not type in all caps. It is considered to be very rude.
--
Don Guillett
SalesAid Software
"CAPTGNVR" wrote in message
...
DEAR PROGRAMMERS
PLS HELP ME IN THE FOLLOWING:
USING LIST BOX, I MARK THREE SETS OF GROUPS FOR THEIR REWARD SUMS. SO I
USE
THE MULTISELECT AND THEN USE
VB
TO TRANSFER THEIR NAMES. SO FAR SO GOOD.
CHARLIE 100
ROMEO 200
TOM 100
1STGROUP
ALFA 500
BETA 500
GAMA 500
TOP GROUP
LIKE THIS I WILL HAVE MANY GROUPS. ABLE TO GET THE GROUPS ISOLATED BY
USING
LISTBOX AND
VB
.
I AM UNABLE TO WRITE THE SUM FORMULA IN VBTO AUTOMATICALLY CALCULATE THE
TOTAL SUM OF THE BONUS AWARDED FOR THE FIRST GROUP AND TOP GROUP AND SO
ON.
PLS HELP
WHAT I AM UNABLE TO DO IS AT THE END OF EACH GROUP I AM UNABLE TO ENTER
THE
SUM FUNCTION AS THE NOTATION IS DIFFICULAT AND NO IDEA HOW TO MAKE THE
STATEMENT IN
VB
USING OFFSET OR HOW TO MAKE OUT IN
VB
HOW MANY CELLS TO
THE
TOP IT MUST ADD. LIKE SUM( D20.D10).
THANKING YOU
CAPT VENKAT RAJARAM
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett