Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UNABLE TO PUT THE SUM FORMULA IN VISUAL BASIC
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UNABLE TO PUT THE SUM FORMULA IN VISUAL BASIC
See response in excel.misc.
-- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic insert formula | Excel Discussion (Misc queries) | |||
Visual basic Check Box and the IF formula | Excel Discussion (Misc queries) | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
Unable to open Excel Help and Visual Basic Help | Excel Discussion (Misc queries) | |||
Formula in a cell (in Visual Basic) | Excel Programming |