button(with vb modult) appear if required only , in work sheets

  • Thread starter evelin via OfficeKB.com
  • Start date
E

evelin via OfficeKB.com

I want some calculation to be done by using macros.

For example:
Suppose a sheet contains marks sheet with eng maths and
science of different students
if BUTTON1 is pressed must get in a column English mark total
if BUTTON1 is pressed must get in a column Maths mark total
if BUTTON1 is pressed must get in a column SCIENCE mark total

with each button vb modules for calculating total marks are attached
The problem is
Many different people are doing this Mark tabulation(example only) in
different locations of the same computer system.

The thing is that if they are opening a work sheet for this purpose ,
automatically on cell a1,b1 ,& c1 these button must appear and when clicked-
the code attached to it must start working


Please help me out …Thanks a lot
,thanks, thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with macro lsit 0
Link a text box based on drop down box with four options MS Word 365 0
Hiding a button based on a value in a table 1
Conditional Formatting in VB 0
how to select contents from a col which lies in between other columns 2
Page numbering with Merged Document and IF statements 1
Control Array in PowerPoint VB 1
Comparing a cell value with a range in a table and displaying a response 0

Top