	AllExperts > Experts
	Search

About Richard Rost
Expertise

I can answer any questions pertaining to Microsoft Visual Basic 6.0, Microsoft Access VBA, and the Visual Basic Language in general. I do NOT use VB.NET or VB 2005/08 much yet, so don't ask me any questions specific to those. Also, please feel free to check the Tips & Tricks section of my web site for VB tips.

Experience
I am the president of VBLearningZone.com and 599CD.com. I specialize in Microsoft Access and Visual Basic Tutorials. I have been teaching in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught VB expert. I have been building software for clients since the early 90s (and on my own since I was a child). You can see a sample of my Tutorials on my web site at 599CD.com

You are here: Experts > Computing/Technology > Basic > Visual Basic > Excel Macros

Topic: Visual Basic

Expert: Richard Rost
Date: 8/17/2008
Subject: Excel Macros

Question
The following macro gives me the error - Invalid use of property & takes me to first .Value line

Public Sub myfirstprogram()
Range("b2").Select
ActiveCell.Value -InputBox("Enter Value")
Range("b3").Select
ActiveCell.Value -InputBox("Enter Value")
Range("b4").Select
ActiveCell.Value -InputBox("Enter Value")
Range("b5").Select
ActiveCell.Value -InputBox("Enter Value")
Range("b6").Select
ActiveCell.Value -InputBox("Enter Value")
Range("b7").Select
ActiveCell.Formula -"-sum(b2..b6)"
End Sub

please tell me why i am getting this error & how to solve this problem.

Answer
You don't have a properly formed statement. Plus, your InputBox is returning a STRING value. You can try converting it to an integer:

ActiveCell.Value = ActiveCell.Value-CInt(InputBox("Enter Value"))

I haven't tested this, but let me know if you have any other questions or comments.

Also, be sure to visit my FREE Tips & Tricks Page at http://www.599cd.com/tips?key=AllExperts

Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Try one of my FREE tutorials at http://www.599cd.com/VB?key=AllExperts

P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.

View Follow-Ups Add to this Answer Ask a Question

About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.