Advertisement

08.10.2004 at 09:12AM PDT, ID: 21088582
[x]
Attachment Details

VBA Macro Help 4 - Easy Point

Asked by vik1109 in Microsoft Excel Spreadsheet Software

Tags: macro, vba

Need a macro that does the following:

1.  Takes the number, dollar, or % that's in the cell, and when the macro is run, increase the decimal place by 1.

so, if the cell says

"2" before the macro is run, then it should say
"2.0" after the macro is run once, and say
"2.00" after the macro is run agin

2.  Need a macro that does the exact opposite also...decrease the existing decimals by 1 place.Start Free Trial
 
Keywords: VBA Macro Help 4 - Easy Point
Title
1 Extract letters from mixed string (Exc…
2 VBA Macro Error
3 Excel Macro
4 macro sum
5 MACRO TO REFER TO A SPECIFIC CELL
6 Cell Format via VBA
 
Loading Advertisement...
 
[+][-]08.10.2004 at 09:45AM PDT, ID: 11764860

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2004 at 09:49AM PDT, ID: 11764904

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2004 at 10:24AM PDT, ID: 11765300

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2004 at 10:27AM PDT, ID: 11765339

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2004 at 11:38AM PDT, ID: 11766151

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.10.2004 at 11:44AM PDT, ID: 11766229

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.10.2004 at 11:48AM PDT, ID: 11766262

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2004 at 12:18PM PDT, ID: 11766595

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.10.2004 at 12:38PM PDT, ID: 11766838

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: macro, vba
Sign Up Now!
Solution Provided By: kay2g
Participating Experts: 4
Solution Grade: A
 
 
[+][-]10.09.2004 at 07:48AM PDT, ID: 12266259

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.03.2004 at 02:53AM PST, ID: 12734494

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.07.2004 at 12:43AM PST, ID: 12761768

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32