| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform loading, but Content (Inside border) is BLANK?
The below (Partial) code is working fine EXCEPT my UserForm1 (which is coming
up on the screen) IS BLANK Inside the border. Obviously, I'd like for the content to SHOW; What do you see as being wrong here? Sub ImportDailys() ' Application.ScreenUpdating = False Worksheets("Data").Activate Range("B2:F30000").ClearContents Worksheets("Start Here").Activate Application.ScreenUpdating = True res = InputBox("Enter Report Day of Month") UserForm1.Show vbModeless Application.ScreenUpdating = False 'To process 1 of 26 ................... End sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform loading, but Content (Inside border) is BLANK?
Never mind,,, Got it Googling...
Added Line DoEvents Problem Solved,, "JMay" wrote: The below (Partial) code is working fine EXCEPT my UserForm1 (which is coming up on the screen) IS BLANK Inside the border. Obviously, I'd like for the content to SHOW; What do you see as being wrong here? Sub ImportDailys() ' Application.ScreenUpdating = False Worksheets("Data").Activate Range("B2:F30000").ClearContents Worksheets("Start Here").Activate Application.ScreenUpdating = True res = InputBox("Enter Report Day of Month") UserForm1.Show vbModeless Application.ScreenUpdating = False 'To process 1 of 26 .................. End sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Border and cell content mis-alligned printing | Excel Discussion (Misc queries) | |||
| Apply bottom border only on filled cells, leaves blank cells without border? | Excel Programming | |||
| Remove content when saving / loading spreadsheet | Excel Worksheet Functions | |||
| Add Newline(s) inside a Cell Without Splitting Content into Different Cells | Excel Programming | |||
| Loading a Userform | Excel Programming | |||
Linear Mode
