Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Spreadsheet Software
  6. / Microsoft Excel

by bebchi on April 8th, 2009

bebchi

Question

Help answer this question below.

What is the Excel VBScript for the following...put a value in cell B1 and a value in cell C1. Then, when I put a value in A1, I need both B1 and C1 to over-write themselves and become the product of A1*B1 and A1*C1. The same for A2,B2,C2 and A3,B3,C3, etc

  • Like
  • Report
Share:
Other

Answers. 2 helpful answers below.

  • by HasntBeen on April 8th, 2009

    HasntBeen

    I'm too lazy and busy to write the script for you, but I'll hint at the general strategy:

    You need to hook up an event handler on cell A1 so that when it changes, your code gets invoked to modify B1 and C1.

    • Like
    • Report

    No comments. Post one | Permalink

  • by mubashiraziz on April 9th, 2009

    mubashiraziz

    you should write the module in Worksheet_Change() or worksheet_calculation() event ....

    Put Condition on Range("A1") > 1 or anything and start procedure else do nothing ........

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading What is the Excel VBScript for the following...put a value in cell B1 and a value in cell C1. Then, when I put a value in A1, I need both B1 and C1 to over-write themselves and become the product of A1*B1 and A1*C1. The same for A2,B2,C2 and A3,B3,C3, etc

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Vbs put value excel
Vbscript on cell change event
Vbscript to put value to a cell
Vbscript to find one value and write another value in excel cell
Vba script event click cell

Answerbag

a Demand Media company