Rezern

Hi

Since I'm not a heavy programmer things kind of stopped for me when i realised that i had to write some code in Excel in order to get some buttons to do some commands.
So I'm just hoping that some of you have time time to check out this "simple" code and explaine what each line does

thx i advance

CODE:
seksfot Makro
Makro registrert 12.02.2002 av Maskin

Sheets("Deck cargo").Select
Range("G3").Select
ActiveSheet.Shapes("Rectangle 1").Select
Selection.Characters.Text = "6 fot"
With Selection.Characters(Start:=1, Length:=5).Font
.Name = "Arial"
.FontStyle = "Normal"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Selection.Copy
Sheets("Deck Cargoplan").Select
Range("BH30").Select
ActiveSheet.Paste
End Sub
Sub nifot()

nifot Makro
Makro registrert 12.02.2002 av Maskin



Sheets("Deck cargo").Select
ActiveSheet.Shapes("Text Box 3").Select
Selection.Copy
Sheets("Deck Cargoplan").Select
Range("BH28").Select
ActiveSheet.Paste
End Sub

__________________
CPU-Z: Here AMD clock help tool: Here Speedfan: Here Super pi 1.4: Here Prime 95: Here Driver cleaner: Here Core temp: Here
My CPU-Z validation

magus.tsf

- Selects the worksheet named Deck Cargo
- Selects range G3 on that sheet
-Also selects the shape named Rectangle 1
-Adds the words "6 fot" to the selection
- changes font for the text
- copies the selection to the clipboard
-Selects the worksheet named Deck Cargoplan
-Selects range BH30 on that sheet
- Pastes the content of the clipboard to that range



This one selects the same sheet and copies text box 3 and then pastes it to the range named BH28 on the deck cargoplan sheet.

Hope this explains it a bit.

Rezern

Thanks for that,helps me alot

__________________
CPU-Z: Here AMD clock help tool: Here Speedfan: Here Super pi 1.4: Here Prime 95: Here Driver cleaner: Here Core temp: Here
My CPU-Z validation

magus.tsf

np

Black Magix

Is that some form of basic? doesn't look like VB.

__________________

If you can read this, thank a teacher. If you can read this in English, thank a veteran.

magus.tsf

microsoft vba (visual basic for applications) it only works in office

__________________

The Black Mesa Survivors Club

Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by itslef but the wrod as a wlohe.