I want to return to the userform if the msgbox occurres (then a text / listbox is empty) so the textbox can be filled before populating the data to the worksheet.
Can anyone help me please?
Please Login or Register to view this content.
I want to return to the userform if the msgbox occurres (then a text / listbox is empty) so the textbox can be filled before populating the data to the worksheet.
Can anyone help me please?
Please Login or Register to view this content.
Last edited by dbjofo; 02-06-2014 at 11:26 AM.
It looks like you want something like
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi mikerickson.
Then I get a Compile error: Else without If
You may replace your If line with this code:
Please Login or Register to view this content.
Last edited by Izandol; 02-06-2014 at 12:48 PM.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Sorry that doesnt work either.
With this code I dont even get a msgbox! And the data from the textboxes are inserted in the worksheet even though I want to wait until all textboxes are filled!
Last edited by dbjofo; 02-06-2014 at 12:06 PM.
Please provide a sample workbook.
Sample.xlsmHere you go
Thank you so much
Last edited by dbjofo; 02-06-2014 at 12:46 PM.
Please Login or Register to view this content.
I apologise - it appears I missed a line when I copied the code parts from testing. I have corrected this - please copy the code again.
GREAT!
One last thing! I only need to have a value in either checkbox1 or checkbox2
How do I fix this?
Perhaps this:
Please Login or Register to view this content.
Andy this is great!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks