VBA coding

Hi everyone

I am very new to vba coding. Though time to time I record macros. Some I 
want to edit my macro but I don't the vba codes. It there a place where all 
the codes/coomanda are stored.

thanks
Nadeem 


0
nadeem57 (11)
11/11/2004 2:21:16 AM
excel 39879 articles. 2 followers. Follow

3 Replies
936 Views

Similar Articles

[PageSpeed] 23

Hi

the easiest way to access your macros to edit them is to choose tools / 
macro / macros, click on the macro you want to edit and press the EDIT 
button - you'll be taken directly to the appropriate code.
(to get back to the workbook you can either close the code window, using the 
top X or use ALT & F11 to switch back and forth between the VBE Window & the 
workbook).

Cheers
JulieD

"Nadeem Shafiullah" <nadeem57@telus.net> wrote in message 
news:%23kIU9y4xEHA.3840@tk2msftngp13.phx.gbl...
> Hi everyone
>
> I am very new to vba coding. Though time to time I record macros. Some I 
> want to edit my macro but I don't the vba codes. It there a place where 
> all the codes/coomanda are stored.
>
> thanks
> Nadeem
> 


0
JulieD1 (2295)
11/11/2004 1:32:00 AM
or alt f11

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:e38kT64xEHA.2676@TK2MSFTNGP12.phx.gbl...
> Hi
>
> the easiest way to access your macros to edit them is to choose tools /
> macro / macros, click on the macro you want to edit and press the EDIT
> button - you'll be taken directly to the appropriate code.
> (to get back to the workbook you can either close the code window, using
the
> top X or use ALT & F11 to switch back and forth between the VBE Window &
the
> workbook).
>
> Cheers
> JulieD
>
> "Nadeem Shafiullah" <nadeem57@telus.net> wrote in message
> news:%23kIU9y4xEHA.3840@tk2msftngp13.phx.gbl...
> > Hi everyone
> >
> > I am very new to vba coding. Though time to time I record macros. Some I
> > want to edit my macro but I don't the vba codes. It there a place where
> > all the codes/coomanda are stored.
> >
> > thanks
> > Nadeem
> >
>
>


0
Don
11/11/2004 12:31:44 PM
right click on sheet tab>view code>insert this>save.
Now, when you enter anything in column F (6) a row will be inserted

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 Then Target.EntireRow.Insert
End Sub


-- 
Don Guillett
SalesAid Software
donaldb@281.com
"Nadeem Shafiullah" <nadeem57@telus.net> wrote in message
news:%23kIU9y4xEHA.3840@tk2msftngp13.phx.gbl...
> Hi everyone
>
> I am very new to vba coding. Though time to time I record macros. Some I
> want to edit my macro but I don't the vba codes. It there a place where
all
> the codes/coomanda are stored.
>
> thanks
> Nadeem
>
>


0
Don
11/11/2004 12:35:55 PM
Reply:

Similar Artilces:

in VBA
Using Office 2003 I would like to reset any custom filter settings from all columns. The following resets Column 1 only: Selection.AutoFilter Field:=1 What is the VBA code to reset Columns 1-17? TIA Dennis Dennis, Selection.AutoFilter You could have found that out by yourself if you had just used Macro Record (as I did). -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dennis" <dmburgess@removespamameritech.net> wrote in message news:961i10teu4q5r2t6rh38bmen6lski9r6f6@...

Bug Rep: Excel 2007 .xlsm file not saving commented codes
since i've tested this agaist 2 different copies of Excel 2007 fresh install on different machines at home, i think it's clearly a bug. ok, in order to save vba codes now in excel 2007, i'd have to save files in the .xlsm format. that's cool. everything been working sweet, until... spent 4 long days busting my butt during the new year, missed all the nice parties to rush this stupid project out, and 2 hours being scream at by my boss over skype kinda ate my heart out. how can such a simple mistake be made? very very easy >:Errrrrrrr go on any sheet that has codes ...

Using A Macro/VBA code to re-set formulas
Hi can any one help me with a Macro/VBA code to re-set formulas in pre-defined set of cells i.e. in my case C14:C40 At present I have a copy of the Formulas in another part of th worksheet and when I want to reset the worksheet (as the user can ove right the formulas as the formula is based on either the sum of anothe two cells or the users input) I use a Macro to copy and paste (special the formulas. What I require is a Macro/VBA Code which already has the formula store in the actual Macro/VBA code i.e. so they are not stored as copy in m worksheet Ay help would be greatly appreciated T...

slow code
i've made a code that searches one optional column for duplicates and deletes 2-6 cells in the same row as a duplicate data is found. I'm using this code a lot and my problem is that it can take very long time for the code to run, it can take 1 hour or more if i'm searching like 15000 rows. I'm going to the last cell in my row and uses the countif command to determine if there are duplicates, if not then i go to the cell above and run an new countif. is there a faster way to do this? jocke ------------------------------------------------ ~~ Message posted from http://www...

VBA moving and adding data
I have this appliaction that spits out a format that is not usable for me, but with some minor changes it would be good to go. I just don't know how the code would work. here is what part of my file looks like: ColumnA Coulmn B Column C Column D FAULT F02 8 PILLAR 3018169.273 492458.0997 -9771.365343 3017502.798 493106.6833 -8696.365343 3016836.323 493755.2668 -7621.365343 3016169.848 494403.8503 -6546.365343 3015503.373 495052.4339 -5471.365343 Here is what I would like it to look like: ColumnA ...

Splitting code to modules ... HOW ?
I have build several Excel VBA applictions, but many of them use som same code and functions. I like to put the code into ONE base module. How must I create the module, export it ? And how to refer to it in al the programs I like to use the base module ?? Roel -- Message posted from http://www.ExcelForum.com Roel If the macros are in several workbooks copy them into the same book and save this as Personal.xls The personal workbook may not be visible when you start Excel but the macros will be available to all workbooks. Alteratively, save the macro as an addin e.g. "myFile.xla&...

VBA calling sp with ANSI_NULLS set ON
Hi, On Query Analyzer, I created a sp as follow: > > if exists (select * from dbo.sysobjects where id = object_id(N'dbo.PCS_SEG1') and OBJECTPROPERTY(id, N'IsProcedure')= 1) DROP PROCEDURE dbo.PCS_SEG1 GO CREATE PROCEDURE dbo.PCS_SEG1 as set ANSI_NULLS on set ANSI_WARNINGS on ** sql statement *** > > I need the to set ANSI_NULLS and ANSI_WARNINGS on as it involves another server using linked server. When executing the sp from query analyzer, it works fine too: > exec PCS_SEG1 > But, when I called from VBA, I received error: Heterogeneous queries require t...

Colour code from different servers
-- I collect mail from 2 different servers and I was wondering if it is possible to have them show in the IN BOX in different colours. I know I can select different senders by colour but I want to show all senders that came from each server. Can anybody help Pete A "Pete A" <PeteA@discussions.microsoft.com> wrote in message news:EB77DCA6-A07E-47E9-AD04-62C8B6BC1193@microsoft.com... > > -- I collect mail from 2 different servers and I was wondering if it is > possible to have them show in the IN BOX in different colours. I know I > can > select different se...

Hiding and Unhiding Forms In Code
This is what I am trying to do. I hide a form and opened another form using a button: Me.Visible=False DoCmd.Open "Select Report Type", acNormal Now I want to unhide the form again using a button on the second form, I tried: If Forms![Inscope Site Summary].IsVisible=False Then Forms![Inscope Site Summary].Visible=true End If But this didn't work. I am stuck. Any help will be greatly appreciated. Thank you. Here is an example of using the IsVisible property (straight from your friendly Access help file); If Me!CategoryID.IsVisible Then Me!Line0.Visible = Tr...

how do i change or make this macro??? pictures and code included
i need to either make this from scratch or change it to suit my needs. Firstly a link to the template it is from http://www.exinfm.com/excel%20files/FY2000WhatIf.xls the code is Sub projection() Dim revgrowth As Single, costpercent As Single, smgrowth As Single devgrowth As Single, gagrowth As Single Dim intincome As Integer, noncontitems As Integer, otherexps A Integer Dim taxrate As Single, avgshares As Integer 'dialog box gets displayed With DialogSheets("dialog3") If .Show = False Then Exit Sub End If revgrowth = .EditBoxes(1).Text costpercent = .EditBoxes(2).Text smgrow...

Excel VBA
I have a workbook that has multiple worksheets and 2 of them are letters. I would like to autofill data into the letters by using the userform. I have been able to code it using 1 worksheet. Is it possible to use same userform for the different worksheets? Thank you! Very simple, but you need to be more specific if you want some aid. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "djshides" <djshides@discussions.microsoft.com> wrote in message news:51B36917-FC0E-4567-B7D7-4B37E8A365B1@microsoft.com... > I have a workbook t...

Excel VBA
Hi Excel VBA advisers! I have a userform where there are two text boxes (drugdesc1 & drugdesc2) that I want to force 4 commas to be keyed into both fields. 4 commas are MANDATORY in each text box & are used to separate the type of input within each. ie; brand name, ingredients, strength, form, pack size. (FYI: Later on, I split these fields into 4 separate columns based on the comma delimiter.) When "cmdAdd" command button is clicked, I need to display a msgbox to advise user and disallow the add. I imagine that the code (repeated for each text box) that I would put in th...

How to select combobx value with vba?
For an electrical part number quoting application developed in Excel 2000, I have a a userform (userform4) with a combobox (cboQpn) to hold the quoted part number, and another combobox (cboFormula) prepopulated with a named range (Partnum) The user types in a part number in cboQpn and then chooses the correct formula from cboFormula. Now in access I have a table (tblDetail) that holds previously quoted part numbers and their details--the formula used in the previous quote, for example. The formula information is in column 5 in tblDetail I want to emulate the manual selecting o...

VBA Function to explode string
Hi. I am wanting to know hbow I would go about getting the following 3 cells: Cells A1, A2, A3: :: 1-4,6,8 50 S1B1:: Into a form that looks more like this ::A1 A2 A3 1 8.33 S1B1 2 8.33 S1B1 3 8.33 S1B1 4 8.33 S1B1 6 8.33 S1B1 8 8.35 S1B1:: How it does the rounding (and on which one), it does not matter! Thanks, Tom -- tomjermy ------------------------------------------------------------------------ tomjermy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24666 View this thread: http://www.excelforum.com/showthread.php?threadid=382414 You haven't exp...

Adding to a list of codes
Hi In Excel 2003 I have a spreadsheet listing a large number of cost centres. Each month I am given a list of the cost centres and expenditure against them, which I want to use a look up to populate in to a master spreadsheet. However, during the month new cost centres could have been created. What I would like to be able to do is run a macro against the monthly return and compare the codes contained in it to the codes already listed in the master sheet. If there are any new codes not already in the master sheet I would want them added to the existing list so that the mast...

C-DLL-VBA-EXCEL strings
Hello, I'm trying to connect excel to a C dll library (call C dll from excel through the VBA). It works well for returning integer and double values (see simple example below), but I can't seem to get it to return strings. I am using MinGW gcc (so basically only C) to construct my dll, so I don't have access to BSTR and other cpp like objects/functions... Is there a way to make the C dll return strings to excel? Thanks DLL.c #ifdef BUILD_DLL #define EXPORT __declspec(dllexport) #else #define EXPORT __declspec(dllimport) #endif EXPORT int __stdcall add2(int num){ return num + 2; ...

Outlook error codes
I would appreciate any help! Outlook 2007 refuses to startup, error messsage: catastrophic failure (0x8000FFFF) and the following: C:\Users\Matt\AppData\Local\Microsoft\Outlook\ Outlook.pst is not a personal folders file. error code now being displayed: 0x80040119 (is this a registry problem?) the above was the default folder and as such contains a large amount of my inaccessible data Have been unable to activate (or even locate) inbox repair tool (Scanpst.exe), which I understand was installed with Outlook have neutralized spyware uninstalled and reinstalled Outlook 2007, to no ...

bar code help, adding asterix to reference
Hi, A simple one im sure, cell b4 contains a number, i want cell c4 to display the same number with an asterix (asterisk?) at either side for my bar code font? ="*",B4,"*" What's the correct way to enter this? Many thanks as ever, Rick ="*"&A1&"*" seems to work after some trial and error, could there arise a problem doing it this way? Thanks, Rick "R D S" <ricknewsgroup@members.v21.co.uk> wrote in message news:352cf1F4gusjfU1@individual.net... > Hi, > A simple one im sure, cell b4 contains a number, i want cell c4...

VBA help #3
Hi, I'm an excel VBA total novice. I dabble in access vba, but am unsure where to start in excel. What I need is some code I can tie to a macro (& keyboard shortcut) which will find all values under 1000 in the selected range and change them to 1001. Can anyone point me in the right direction? Any help greatly appreciated.....thanks, Jason Look in the vba help index for FINDNEXT. There is a good example. c.value=1001 -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "Jay" <dummy@dummy.dummy> wrote in message news:eYGxqeELIHA.3...

Getting a Return Value from a Stored Procedure in VBA
Hi all, I have a Stored procedure, here: PROCEDURE [dbo].[new_tbox] -- Add the parameters for the stored procedure here @slide_id int, @shape_id int, @cnt_typ_id int AS BEGIN DECLARE @cnt_id int, @tbox_id int INSERT cnt_info VALUES(@slide_id, @shape_id, @cnt_typ_id) SET @cnt_id = @@IDENTITY INSERT tbox_cnt VALUES(@cnt_id) SET @tbox_id = @@IDENTITY RETURN @tbox_id END That returns the variable. This works in SQL Server, and I get the return value My VBA code from my ADP is as such: With cmd .ActiveConnection = ConnStr .CommandText = "...

which code for the SpellLang in English ?
Hi, I created an Excel file (XP/XL:2000) which is using the check spelling with the code : Range(Cells(19, 2), Cells(50, 9)).CheckSpelling SpellLang:=1033 I would like to know the valid number version for the SpellLang, according to the US language The number 1033 is actually valid for the french language of north America .... Fran´┐Żois I just ran a test using English and the Macro recording feature. It spit this out: ActiveCell.FormulaR1C1 = "spelling something wronge" Range("J6").Select Cells.CheckSpelling SpellLang:=1033 It would appear that 103...

VBA question confused
I have a form set up with a recordset. I'm also using a filter. Me.Filter = "position IN ('custody','sgt','lieutenant','captain', 'other') and shift IN ('a-days','day shift','afternoon shift')" Me.FilterOn = True I'm trying to get an order by the last name field. I read Allen Brown's page about setting the order. I've also read other pages on this board that basically says it can't be done. So, I wrote an SQL that would give me what I want. strSelect = "SELECT * " & _ ...

escape from vba-loop
hi group, I've got an excel-sheet containing some vba-code. There's one sub that does some calculations in a loop which can run for some time. My users now want to be able to escape from this calculation by pressing <escape> or clicking a button on the sheet. But actually excel is frozen while calculating. What is the most common way to achieve this? I guess it must be possible to solve this with excel-events, but I'm not very experienced in using them. thanks for any hints, stephan You can add a "DoEvents" statement inside the loop. Excel checks for any instruc...

How to show Excel chart VBA 'name'?
Hi, I have several charts on every Excel Worksheet. I'd like to program VB to select them. In order to do so, I need to know the 'name' of eac chart. How to display it quickly? Maybe you know a kind of add-in that has a kind of nutton like 'sho chart name'? Thanks, Micha ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Hi Michal, Just hold the Shift key before selecting the chart. The name will be displayed in the Name Box (where the cell address ...

Modifying the lookup window with VBA to sort by a column
How do I add VBA code so when I use the lookup button in Payroll Transaction Entry that it will default to the Last Name Sort and start with the name entered on the Payroll Transaction window in the Employee ID field. Thank you, Amy Amy You did not say which version, but if you are using the Advanced Lookup windows, then you can set some defaults for these windows on Tools >> Setup >> Company >> Advanced Lookups. Which will mean you don't need VBA on this window. Kind Regards Eddie Fourie MBS Specialist (Available for outsourced projects) -----Original Message---...