ActiveSheet.TextBox1.Activate

**zplugger** · 09-13-2012, 12:12 PM

I use this code in workbook open to default the cursor to Textbox1, it gives me a lot of screen flicker on open. Is this
normal or is there a different way to default the cursor?

Please Login or Register  to view this content.

**JosephP** · 09-13-2012, 12:46 PM

are you sure it's that line that causes it? does it have the same effect if you run it after the workbook opens?

**zplugger** · 09-13-2012, 01:47 PM

If I delete the code on open, no flicker. I Put the code on a commandbutton and get no flicker when pushed. Getting
flicker on open only,might have to live with it??

**JosephP** · 09-13-2012, 03:32 PM

try putting the code into a sub in a normal module then in the workbook open use

Please Login or Register  to view this content.

**zplugger** · 09-13-2012, 04:10 PM

Thanks Joseph, still flickers. I change the code to 5 seconds and still flickers. If I delete the code in workbook open no flickers. I did find
a work around for my needs,I have a large listbox on the page so I put the code in a mouse move and get no flicker. Strange. The timer code is pretty cool,I will save it
for another project.
Z