Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-12-2024, 06:28 AM
Italophile Italophile is offline 1. Apply to current row.   2. De-select row afterwards. Windows 11 1. Apply to current row.   2. De-select row afterwards. Office 2021
Expert
 
Join Date: Mar 2022
Posts: 542
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

You're welcome.

Recording a macro can be a useful step in discovering the syntax for an action, but the code produced, if any, will be of inferior quality.

The VBA editor has some tools that can help you learn and which are only a keypress away.
  • F1, when the cursor is in a keyword, brings up the online documentation.
  • F2 displays the Object Browser which can help you to discover the objects, their methods, properties, and events, that you can work with. You can either browse the object tree or use the find button to discover potentially useful properties or methods. In the 30+ years that I have been writing VBA this has always been the most helpful tool for me.

Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to apply Heading1 to select rows bobk544 Word VBA 3 06-09-2018 05:24 AM
VBA Word Table - Select More than 1 Column at a time - Apply Formatting jc491 Word VBA 12 09-24-2015 06:03 AM
1. Apply to current row.   2. De-select row afterwards. How to select the first row of the current table Jennifer Murphy Word VBA 9 01-29-2012 06:50 PM
1. Apply to current row.   2. De-select row afterwards. How to call current PC date and/or current PC year KIM SOLIS Excel 2 11-04-2011 06:09 PM
1. Apply to current row.   2. De-select row afterwards. Auto insert current month's name and current year Styler001 Word 4 01-25-2010 06:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:18 PM.


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