ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VB Code and Excel (https://www.excelbanter.com/excel-worksheet-functions/52032-vbulletin-code-excel.html)

SMBR

VB Code and Excel
 
I am slightly familiar with VB Code due to working in Access. I have seen
posts suggesting code for different things in Excel. My only question is,
and I apologize if this is completely ignorant, but where is the code entered
into for the cells of Excel? I have used most of VB in Access via macros.

Paul B

VB Code and Excel
 
SMBR, have a look here and see if this will help,

getting started with macros

http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"SMBR" wrote in message
...
I am slightly familiar with VB Code due to working in Access. I have seen
posts suggesting code for different things in Excel. My only question is,
and I apologize if this is completely ignorant, but where is the code
entered
into for the cells of Excel? I have used most of VB in Access via macros.




Gord Dibben

VB Code and Excel
 
VBA code is not entered in cells.

It is entered in modules and called via one or more of many different methods.

See David McRitchie's site for getting started with VBA and Macros.

http://www.mvps.org/dmcritchie/excel/getstarted.htm


Gord Dibben Excel MVP


On Mon, 24 Oct 2005 12:39:49 -0700, "SMBR"
wrote:

I am slightly familiar with VB Code due to working in Access. I have seen
posts suggesting code for different things in Excel. My only question is,
and I apologize if this is completely ignorant, but where is the code entered
into for the cells of Excel? I have used most of VB in Access via macros.




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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com