Combo box linked cell

[ksmith]

quick question--- how can I get the "linked cell" in a combo box to link to a cell on another worksheet?

thanks!
kyle

 

[ksmith]

ok, i figued out a way to do it, but if anyone has a better way, let me know.

Private Sub ComboBox4_Change()
Sheets("shipping instructions").Select
ActiveSheet.Range("C20").Select
activeCell.Value = ComboBox4.Value
Sheets("freight quote").Select
End Sub

 

[lenze]

In the linked cell property field, enter

'shipping instructions'!C20