Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-14-2013, 12:49 PM
mickeyd mickeyd is offline auto-indent Windows 8 auto-indent Office 2010 64bit
Novice
auto-indent
 
Join Date: Jun 2013
Posts: 1
mickeyd is on a distinguished road
Thumbs down auto-indent

I'm almost a total novice at macros. I have some understanding of the "logic" behind macros, but limited experience.



What I want to do is write a macro where the number in cell A1 will cause the data in B1 to indent based on that number. I assume the macro would go in B1 and look something like: =IF(A1=1)then (B1=0).

Example: if I put the number 1 in A1, I want the data in B1 to stay at 0.
If I put the number 2 in A1, then I want the data in B1 to indent 1 space.

Now comes the tricky part. I want the macro to cover 6 indentations. If A1 =3, then indent 2 spaces. If A1=4, then indent 3 spaces, etc.

Hope that makes sense.

Thanks,
Mickey
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Accidental automatic indent? markg2 Word 8 12-10-2012 06:45 PM
auto-indent -right indent?- markbh Word 3 07-16-2012 02:59 PM
Indent Problem adamsoa Word 1 05-07-2012 10:58 PM
auto-indent Indent Problem lkatz1 Word 3 11-16-2011 12:01 AM
Hanging Indent bixby Word 0 07-22-2010 07:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft