next simple code sample !

'Code to set the current active cell value to something

Sub SetValue()
Worksheets("Sheet1").Activate
ActiveCell.Value = 35
End Sub

More Office Manuals ...

Dont forget to check out www.interquadbooks.co.uk for a now updated library of Computer Reference Books !


Jamie

Get your Code into Action ...

I almost forgot ....

Copy and Paste the code into the VB Editor window maybe on the first sheet or the This Workbook page, Save it !!! and then test it out by running the Code from the Run icon.


PS you could create an icon on the Toolbar to run the Macro later if you are feeling brave !!

Jamie

VBA for EXCEL Code Snippets

Hi all ,
I will be adding a little bit of code here and there to the BLOG in the form of Excel Code as I find out a little more on the subject as I go along the path to becoming a VB person !! [anorak not included]

Heres some code that uses the InputBox Function to then add a number of required additional worksheets to your Spreadsheet.

' Code to create additional Worksheets
Sub AddXWorksheets()
Dim myNum As String

myNum = Application.InputBox("Enter the number of additional WorkSheets required")
Worksheets.Add After:=Worksheets(Worksheets.Count), Count:=myNum
End Sub

Thankyou !

Need some sample data to play around with Excel 2007 ?

Then try Mr Excel ...

http://www.mrexcel.com/miraclesfiles.html

These files are from the Book : Excel 2007 Miracles Made Easy by Bill Jelen.

Download a Sudoku Solver here !

"Yes you can solve Sudoku in seconds with MS Excel !"

thanks to Mikes spreadsheet of VB magic !

download from :
http://www.mikeoldroyd.com/

PowerPoint Links

Need some professional backgrounds and templates, then check out these links below :
obviously a lot of these sites you will have to pay for the goods !!

http://www.ppted.com/

http://www.powerfinish.com/

Also check out Microsoft Office Online site for some free templates !

http://office.microsoft.com/en-gb/templates/results.aspx?qu=powerpoint&av=TPL000

And also check out :

http://www.presentationhelper.co.uk/free_powerpoint_template.htm

free templates !

Note in PowerPoint 2007 you can have access to a wide range of pre set templates and colour combinations, it makes a lot of the older templates look "out-dated" by comparison.

Thanks

Jamie

Microsoft At Work Website

Useful tips and tricks for Office lovers everywhere !

http://www.microsoft.com/uk/atwork/default.mspx

First look at Office 2007

Try this website for a first look at the advances with MS Office 2007 !
Its a huge new version with lots of great time saving and impressive features across all the applications :
http://www.microsoft.com/uk/office/newday/default.mspx?nav=v1xcsubmenuxi0&WT.mc_id=Online

Good luck

Office Books anyone ?

Web page detailing MS Office books available !

http://www.mousetrax.com/books.html#office

Monthly Training Journal

Hi try MouseTRax for training resources, I found some good help here on all MS Office related apps. You can subscribe for free to get a monthly magazine !

http://www.mousetrax.com/TechPage.html

Cheers
Have a nice Summer break for those of you going on holiday in 2007 !! :)

Jamie

Red RAG to a bull [ Red Amber Green Graphic Indicators]

Hi all
Just done a Project 2003 course and we discovered you can set up graphical indicators for your Project Tasks or overall Project status such as a red dot for Warning, Amber and green dot aswell !

I will document the process in a later Blog, but its a New Custom Field then choose Graphical indicators, when the user selects a drop down option such as R, A or G it uses a graphic instead of text.

A more interactive approach lets you copy a Number column such as Cost or Variance and Paste link it over the top of the indicator column so it keeps changing dependant on the numbers linked to it.

more to follow ...

Jamie

Outlook Keyboard Shortcuts

In a hurry with E-Mail , then peruse the shortcuts below :

Function keys

F1 -- Open Help
F3 -- Open Find dialog or Find pane.
F4 -- Expand dropdown menus, use arrow keys to select from list
F5 -- Refresh the current window (Outlook 2003) - Send/Receive in older versions
F6 -- Move to next window element
F7 -- Run spell check F9 -- Send/Receive


Number Keys

Ctrl+1 -- Inbox
Ctrl+2 -- Calendar
Ctrl+3 -- Contacts
Ctrl+4 -- Tasks
Ctrl+5 -- Notes
Ctrl+6 -- Folder list
Ctrl+7 -- Shortcuts
Ctrl+8 -- Journal
Ctrl+Y -- Folder picker dialog

Print a list of shortcut keys from within Word ..

Ever wondered how to get your own list of keyboard shortcuts ???

Read on .....

1. On the Tools menu, point to Macro, and then click Macros.
2. In the Macros in box, click Word commands.
3. In the Macro name box, click ListCommands.
4. Click Run.
5. In the List Commands dialog box, click Current menu and keyboard settings.
6. Click OK.
On the File menu, click Print.

MOS SOS !!

Become MOS qualified and be the best !!

http://www.microsoft.com/learning/mcp/officespecialist/default.mspx

JJSURF

Demystify a few computer terms and get on with your life

Crabby to the rescue to bust some jargon !
http://office.microsoft.com/en-gb/help/HA010429491033.aspx

JJSURF and Crabby Office Lady.

Put Word to work for you!

Five handy tips for use with MS Word courtesy of Microsoft :
http://office.microsoft.com/en-gb/word/HA101154421033.aspx

JJSURF

Pretty Ribbons ....

Here's the Ribbon. Note the expandable Groups such as Clipboard and Font. The Office button at top left gives you access to the File Open, Save, Print commands plus others.

Home , Insert Page Layout etc are positioned across the top of the Ribbon.

Dont worry you will soon get used to it !!!

JJSURF

The Crabby Office Lady is alive and well !!!

Yes folks she's still around dishing out advise, like it or not check out her latest Office ravings below :

http://office.microsoft.com/en-gb/help/FX101679371033.aspx

JJSURF

You can use Shift Control + H to open a Word, Excel or PowerPoint document from within MS Outlook.. give it a try !!

JJSURF