Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel VB Macros

Thread Tools
 
Search this Thread
 
Old 15 July 2003, 04:27 PM
  #1  
DJ Dunk
Moderator
Support Scoobynet!
Thread Starter
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Question

I'm still used to using the old Excel 4.0 macros How do you make it record macros using relative rather than absolute references in the VB version ?

Thanks
Old 16 July 2003, 08:43 AM
  #2  
Bajie
Scooby Regular
 
Bajie's Avatar
 
Join Date: Dec 1999
Posts: 2,221
Likes: 0
Received 0 Likes on 0 Posts
Post

When you press the Record Macro button on the toolbar that appears is the Relative/Absolute toggle. Press this to switch between the two.
Old 16 July 2003, 08:46 AM
  #3  
DJ Dunk
Moderator
Support Scoobynet!
Thread Starter
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Thumbs up

Bajie - Nice one, thanks Never noticed that
Old 16 July 2003, 09:03 AM
  #4  
Bajie
Scooby Regular
 
Bajie's Avatar
 
Join Date: Dec 1999
Posts: 2,221
Likes: 0
Received 0 Likes on 0 Posts
Thumbs up

No worries DJ

Transition to VBA is not so bad. Been using it since they changed with Excel 5.0. Frustrating to begin with but if you save one of your old Macro's to a newer version of Excel it will convert the code for you. Then have a look at the new code and see what you make of it.

Good Luck
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
leg200
Subaru Parts
5
07 October 2015 07:31 AM
has-scooby
Subaru Parts
4
06 October 2015 03:47 PM
bluebullet29
General Technical
9
05 October 2015 02:17 PM



Quick Reply: Excel VB Macros



All times are GMT +1. The time now is 11:54 AM.