Navigate between userform and worksheets

[mirrorwatch]

I have designed a userform and it contains some functions like it copies certain values into different worksheets.But now I want to access those worksheets, so how can I do that?

So the question is

At the moment, the only way is that to close the userform, and then start using the worksheets, I do not want that, I want to able to do both things at the same time

 

[VoG]

You need to show the form modelessly

UserForm1.Show vbModeless

 

[mirrorwatch]

You need to show the form modelessly

UserForm1.Show vbModeless

thanks.

Any other suggestions with userform to make the overall process more smoother?

 

[VoG]

What is your code that displays the UserForm?

 

[mirrorwatch]

What is your code that displays the UserForm?

It has been corrected.

Another question, how to clear all the values of a listbox within a macro in the module?

 

[VoG]

That depends how the listbox is populated. See http://support.microsoft.com/kb/q165632/

 

[mirrorwatch]

And what about for combobox

I do not want to remove all items but just clear the selected value?

 

[VoG]

Maybe like this

With UserForm1.ComboBox1
    .AddItem ""
    .ListIndex = .ListCount - 1
    .RemoveItem .ListCount - 1
End With

 

[mirrorwatch]

One last question,

what about for textbox in the userform? How to clear its value using a macro in module?

Thanks a lot for answering so many questions in little time.

 

[VoG]

Try like this

UserForm1.TextBox1.Value = ""