Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 10th 07, 06:27 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 390
Default Is there a step by step procedure on macros?

I have a amcro and cannot get it to run, I have come to the conclusion that I
must be doing something basic wrong. Our company tech. support cannot see
anything wrong, so it must be something overlooked.

  #2   Report Post  
Old May 10th 07, 08:23 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default Is there a step by step procedure on macros?

Bill,
Can you post your macro?

"Bill" wrote:

I have a amcro and cannot get it to run, I have come to the conclusion that I
must be doing something basic wrong. Our company tech. support cannot see
anything wrong, so it must be something overlooked.

  #3   Report Post  
Old May 10th 07, 01:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Is there a step by step procedure on macros?

Go into the VBE and click inside the procedure.
Hit F8 to step through the code.

If this doesn't help, you may want to post the code (like Toppers suggested) and
post more details--where is the code located, how you start the macro.

And make sure you've enabled macros when you opened the workbook.

Bill wrote:

I have a amcro and cannot get it to run, I have come to the conclusion that I
must be doing something basic wrong. Our company tech. support cannot see
anything wrong, so it must be something overlooked.


--

Dave Peterson
  #4   Report Post  
Old May 10th 07, 10:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 390
Default Is there a step by step procedure on macros?

This is the macro and it is in the this workbook module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target(1, 1).Address = "$C$5" Then
With Worksheets("LogSheet")
.Cells(.Rows.Count, 1).End(xlUp)(2, 1).Value = Target(1, 1).Value
End With
End If
End Sub


"Dave Peterson" wrote:

Go into the VBE and click inside the procedure.
Hit F8 to step through the code.

If this doesn't help, you may want to post the code (like Toppers suggested) and
post more details--where is the code located, how you start the macro.

And make sure you've enabled macros when you opened the workbook.

Bill wrote:

I have a amcro and cannot get it to run, I have come to the conclusion that I
must be doing something basic wrong. Our company tech. support cannot see
anything wrong, so it must be something overlooked.


--

Dave Peterson

  #5   Report Post  
Old May 10th 07, 10:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Is there a step by step procedure on macros?

The Worksheet_Change event doesn't belong in the ThisWorkbook module.

Worksheet_Change belongs behind the worksheet that's getting the change.

There is a Workbook_SheetChange event, though. (But I bet you're looking at one
sheet. So I bet this doesn't apply in your case.)

Bill wrote:

This is the macro and it is in the this workbook module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target(1, 1).Address = "$C$5" Then
With Worksheets("LogSheet")
.Cells(.Rows.Count, 1).End(xlUp)(2, 1).Value = Target(1, 1).Value
End With
End If
End Sub

"Dave Peterson" wrote:

Go into the VBE and click inside the procedure.
Hit F8 to step through the code.

If this doesn't help, you may want to post the code (like Toppers suggested) and
post more details--where is the code located, how you start the macro.

And make sure you've enabled macros when you opened the workbook.

Bill wrote:

I have a amcro and cannot get it to run, I have come to the conclusion that I
must be doing something basic wrong. Our company tech. support cannot see
anything wrong, so it must be something overlooked.


--

Dave Peterson


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need step by step instructions to try, not a demo. Can't remember [email protected] Excel Worksheet Functions 1 June 15th 06 09:24 PM
Need step by step instructions to try, not a demo. Can't remember [email protected] Excel Worksheet Functions 0 June 15th 06 10:05 AM
can't install CD from Excel 2003 step by step djclark New Users to Excel 0 February 9th 06 11:31 PM
What is the step-by-step procedure for making a data list? Bobgolfs56 Excel Discussion (Misc queries) 1 April 23rd 05 02:19 PM
I need step by step instructions to create a macro for 10 imbedde. diana Excel Worksheet Functions 3 January 31st 05 01:56 AM


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017