PDA

View Full Version : How to retrieve Value in Frame in user form



yogeshwarv
08-01-2011, 07:31 AM
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
08-01-2011, 07:43 AM
What Invoice? What in frame? There is nothing there.

shrivallabha
08-01-2011, 08:07 AM
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):
Private Sub UserForm_Initialize()
Label1.Caption = Sheet1.Range("K1").Value
End Sub