LinkBack URL
About LinkBacks
Greetings,
1- Open enclosed file.
2- Run Macro1.
Question: How to enter something into cell when WScript.Popup box is active?
Please Login or Register to view this content.
Greetings,
1- Open enclosed file.
2- Run Macro1.
Question: How to enter something into cell when WScript.Popup box is active?Please Login or Register to view this content.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Consider using a custom userform displayed with vbModeless
UserForm1.Show vbModeless
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hello HerryMarkowitz,
I am not sure why you decided on using the Windows Script Host for a dialog box when other better choices exist. The code below uses an InputBox to accept the name and then transfer it to the correct cell. It has been added to the attached workbook.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi AlphaFrog,Originally Posted by AlphaFrog
UserForm1.Show vbModal :
You can not interfere in any cells if UserForm is vbModal.
However, excel screen stops if there are some other codes after UserForm1.Show vbModal line.
UserForm1.Show vbModeless :
You can interfere in any cells if UserForm is vbModeless.
But, excel screen does not stop if there are some other codes after UserForm1.Show vbModeless line.
So, both methods are not useful for my needs...
Last edited by HerryMarkowitz; 03-22-2015 at 08:05 AM.
Hi Leith Ross,
InputBox is not good idea.
Because I need to check any cells in the sheet, and want to interfere any cells...
I am so sorry that, I couldnt ask this question clearly at first.
Last edited by HerryMarkowitz; 03-22-2015 at 07:52 AM.
Create two procedures;
1.) one for code before the userform and to show the userform,
2.) the 2nd procedure for any code after the userform is done.
The userform calls the 2nd procedure when it terminates.
Please Login or Register to view this content.
Userform with two controls; CommandButton1 and Label1
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks