PDA

View Full Version : Solved: How to make image of code



tomjoe
02-23-2008, 04:30 AM
I have Excel 2007.
I cannot find out how to make image of VBA codes to post it as an image in f.ex. this forum.

:help

Bob Phillips
02-23-2008, 04:47 AM
Just take a screen print and post it as a jpeg.

tomjoe
02-23-2008, 09:25 AM
Must I have a special program to convert the file to jpeg ?

mdmackillop
02-23-2008, 11:39 AM
Paste you copied picture into Paint and save it from there

tomjoe
02-23-2008, 11:17 PM
I cannot figure out how to paste the image directly into this message box but only as an attachment.

Brandtrock
02-23-2008, 11:39 PM
Paste your picture in Paint as Malcolm suggested. Save the file as a jpeg. Attach that saved jpeg to your post and it will work for you.

Regards,

tomjoe
02-24-2008, 01:55 AM
Private Sub Update(Target As Range)
Dim Tgt As Long, c As Range, d As Range
If Target = "" And cellValueOnEntry Like "[a-z][.][1-9][.][1-9]" Then
Tgt = Target.Offset(, -1)
Set c = Sheets("Lokasjon").Cells.Find(what:=cellValueOnEntry, lookat:=xlWhole, MatchCase:=False)
Set d = c.Resize(5).Find(what:=Tgt, lookat:=xlWhole)
If Not d Is Nothing Then
d.ClearContents
c.Offset(5) = Date
End If
End If
End Sub

Brandtrock
02-24-2008, 02:57 AM
Glad you got it sorted, but the VBA tags simply format the text as if it were code in the VBE, it isn't an image.

The directions given answered the question asked.