Hi,

I have a problem with refedit controls. What i want my code to do is that as soon as de range is selected via the refedit control, the name of the workbook from which the range was obtained should be stored in a sheet. I first did this om the DropButtonClick event, but then i realized that smart excelusers don't use that buttom but just click in the refedit and start selecting the range right away.

I then used the refedit1_Enter() event, but as soon as i want to fill another refedit. my userform just disappears... while VBA is stil running..

with the DropButtonClick() event, this problem doesn't occur..

My code is:

Private Sub RefEdit1_Enter()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

ThisWorkbook.Worksheets("SETTINGS").Cells(4, 12) = ActiveWorkbook.Name

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub

Private Sub RefEdit2_Enter()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

ThisWorkbook.Worksheets("SETTINGS").Cells(3, 12) = ActiveWorkbook.Name

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub

Any help?

Thanks!