Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The strings values - need to evaluate based on alphabetical order

Status
Not open for further replies.

bzsurf

MIS
Nov 13, 2006
1
US
I am writing VBA code for excel. I have three different values from a spreadsheet captured in three different strings (strPRD, strTSR and strPBS). How can i evaluate these strings to determine which one comes first in alphabetical order? Thanks in advance.
 




Hi,

Use an If statement to sort.

Assign to cells in a sheet and sort.

Skip,

[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top