Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-03-2021, 07:58 AM
Souriane Souriane is offline UserForm : Allow user to move cursor in document Windows 7 64bit UserForm : Allow user to move cursor in document Office 2013
Advanced Beginner
UserForm : Allow user to move cursor in document
 
Join Date: Feb 2017
Location: Quebec, Canada
Posts: 82
Souriane is on a distinguished road
Default UserForm : Allow user to move cursor in document


Hi,

I created a userform with 4 buttons. Each button activates a different macro to do something on the text. But one of the macro requires the user to move the cursor from where it is. What is the code to allow the user to do that? Because right now, the way I did it, once the userform is up, the user can't do anything. Can't type, can't move. I need the focus to go back to the document.

Thank you!
Reply With Quote
  #2  
Old 06-03-2021, 03:45 PM
Guessed's Avatar
Guessed Guessed is offline UserForm : Allow user to move cursor in document Windows 10 UserForm : Allow user to move cursor in document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

When you open a userform, you are able to make it modal or modeless. One of these allows you to edit the document while the form is open.

Have a look at this page https://wellsr.com/vba/2016/excel/sh...nd-vbmodeless/
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 06-07-2021, 12:58 PM
Souriane Souriane is offline UserForm : Allow user to move cursor in document Windows 7 64bit UserForm : Allow user to move cursor in document Office 2013
Advanced Beginner
UserForm : Allow user to move cursor in document
 
Join Date: Feb 2017
Location: Quebec, Canada
Posts: 82
Souriane is on a distinguished road
Default

Guessed... you made my day!! It works. Thank you sooooo much!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Find a string and move the cursor to it mdlewis Word VBA 3 02-13-2020 03:53 AM
Move cursor up several lines after form data entered in document zanestein Word VBA 6 05-23-2018 04:01 AM
UserForm : Allow user to move cursor in document move cursor anand Word VBA 14 07-07-2015 05:57 AM
How do I move the cursor back to the text from a comment without using the mouse? MsT Word 2 04-24-2014 05:48 PM
can't move the cursor in Word pieboy Word 2 02-13-2009 07:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft