Copy same info to the another sheet VBA

[Halos]

Hi,

Please see below code. When I run macro, info copying to sheet1. But I need at the same time to copy same information to sheet2. Please help.

Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")

ws.Cells(iRow, 2).Value = Me.combobox_name.Value

 

[Joe4]

Just add another sheet reference and line of code that assigns the value, i.e.

Dim iRow As Long
Dim ws As Worksheet
[COLOR=#ff0000]Dim ws2 As Worksheet[/COLOR]

Set ws = Worksheets("Sheet1")
[COLOR=#ff0000]Set ws2 = Worksheets("Sheet2")[/COLOR]

ws.Cells(iRow, 2).Value = Me.combobox_name.Value
[COLOR=#ff0000]ws2.Cells(iRow, 2).Value = Me.combobox_name.Value[/COLOR]

I trust the value if iRow is being set somewhere prior to this code.

 

[Halos]

Just add another sheet reference and line of code that assigns the value, i.e.

Dim iRow As Long
Dim ws As Worksheet
[COLOR=#ff0000]Dim ws2 As Worksheet[/COLOR]

Set ws = Worksheets("Sheet1")
[COLOR=#ff0000]Set ws2 = Worksheets("Sheet2")[/COLOR]

ws.Cells(iRow, 2).Value = Me.combobox_name.Value
[COLOR=#ff0000]ws2.Cells(iRow, 2).Value = Me.combobox_name.Value[/COLOR]

I trust the value if iRow is being set somewhere prior to this code.

Thanks Joe, but when copying information to sheets, which command we need to add in order to

highlight also border (for example: Borders(xlInsideHorizontal).LineStyle = xlNone)​

 

[Joe4]

Thanks Joe, but when copying information to sheets, which command we need to add in order tohighlight also border (for example: Borders(xlInsideHorizontal).LineStyle = xlNone)

That seems to be an entirely different question than the original one you posted.

If you want to copy formatting too, you will need to use Copy commands. You can use the Format Painter to copy formats.
If you turn on the Macro Recorder, and record yourself doing it manually, it should give you the code you need.

 

[Halos]

That seems to be an entirely different question than the original one you posted.

If you want to copy formatting too, you will need to use Copy commands. You can use the Format Painter to copy formats.
If you turn on the Macro Recorder, and record yourself doing it manually, it should give you the code you need.

Many Thanks Joe.

 

[Joe4]

You are welcome.