How to retrieve Value in Frame in user form

[yogeshwarv]

Hi friends,

I need you help you know how to retrieve next value of Invoice No in frame box of a user form

i have enclosed the excel file for better understanding..

your help is highly appreciated

Regards
Yogeshwar

[Bob Phillips]

What Invoice? What in frame? There is nothing there.

[shrivallabha]

You should consider inserting a label there and then set the label caption using userform initialize event like below (first inserted label will be label1):
[VBA]Private Sub UserForm_Initialize()
Label1.Caption = Sheet1.Range("K1").Value
End Sub
[/VBA]