Inserting a function into a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a function (from cpearson.com) to add numbers in a column that are a
certain color. Now, a very elementary (I'm sure) question: How and where do
I enter this function so I can execute it? I've entered it into the
Microsoft Visual Basic Window. but I don't know how to get it onto the
worksheet in an executable manner. Thanks,

Rich D
Armstrong Custom Homes
Redmond
 
Alt + F11 opens the VB editor. Right click on the project and insert a new
module and paste the function into the module.

It can be called from a worksheet by using the function name and passing the
necessary values to it.
 
You must log in or register to reply here.

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

Adding certain numbers based on... 1
Importing data from Excel worksheet into Excel template 2
'Cannot insert object' message when I try to put a button on a worksheet 7
Inserting function into worksheet via macro 4
Inserting a comment box in a protected worksheet 2
Inserting a list into "If" function 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Inserting Rows into multiple worksheets 2

Back
Top