Bring to front

C

Chris

Using VBA, is there a command to bring a line control to the front
programmatically?

The line cannot be merely set to front via Bring to Front for all instances,
there is occasional interference. VBA coding it to the front would be ideal.
 
M

Marshall Barton

Chris said:
Using VBA, is there a command to bring a line control to the front
programmatically?

The line cannot be merely set to front via Bring to Front for all instances,
there is occasional interference. VBA coding it to the front would be ideal.
Click to expand...

Bring to Front/Send to Back are strictly design time
opreations.
 
B

BeWyched

You could use 2 lines and alternate their visible property. i.e. if you need
to see a line at the back or at the front depending on an event, then
superimpose 2 idetical lines over each other - one at the front and t'other
at the back, then alternate their visible properties:

me.line1.visible = me.line2.visible
me.line2.visible = not me.line1.visible

or something similar.

Cheers.

BW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Creating a Chart on form from selected data in query. 0
Vertical short line in front of word 0
Link a text box based on drop down box with four options MS Word 365 0
Form hides control buttons 0
Using Office Forms and dynamically updating the excel backend 0
Cannot wrap text around an image 1
Slow when "Mark all as read" 3

Top