Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-22-2018, 05:43 AM
ArviLaanemets ArviLaanemets is offline VBA to highlight specific values in the spreadsheet Windows 8 VBA to highlight specific values in the spreadsheet Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by daiwuliz View Post
Can it be done using VBA?
Probably.

I myself use VBA in Excel when:
1. I need an UDF when I can't get the result using worksheet functions (like getting name of n'th file of certain type in certain folder);
2. I need an Open event (e.g. to update parameters of ODBC query to same Excel workbook when the workbook is moved or renamed);
3. The Excel workbook is used as tool to read some data from one source of certain format, and to create another file of another format based on read data.

In any other cases, when there will be need for VBA, I will seriously consider Access or SQL Server instead.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to highlight lines containing specific words SixStringSW Word VBA 4 06-03-2018 03:57 PM
Trying to import specific data from one spreadsheet to another, without matching rows Wynka Excel 0 11-26-2014 09:33 AM
VBA to highlight specific values in the spreadsheet Macro to copy specific columns in Excel from another spreadsheet KD999 Excel Programming 1 07-20-2012 08:58 AM
VBA to highlight specific values in the spreadsheet Looking for a specific spreadsheet DivideByZer0 Excel 3 11-10-2009 05:58 PM
find - reading highlight - highlight all / highlight doesn't stick when saved bobk544 Word 3 04-15-2009 03:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:30 AM.


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