Avatar of Dale Fye
Dale FyeFlag for United States of America

asked on 

Identify which columns in a datasheet are selected

I'm exporting a datasheet to Excel via vba thanks to Nick67 and Capricorn1.  In that code, I exempt those columns from the datasheet that have been hidden by the user.  Now I would like to take that one step further and only export the columns that have selected by the user.  For example, if the user selects several columns that are next to each other and only want to export them.  

Is there a way to identify which columns are selected?  I assume so, since the Find functionality works on "selected" columns.  I just have not been able to identify the specific property of the datasheet or of the controls collection to identify.
Microsoft Access

Avatar of undefined
Last Comment
Dale Fye
ASKER CERTIFIED SOLUTION
Avatar of Nick67
Nick67
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

ASKER

Graham,

We resolved the issue of which columns are visible and the sequence in my previous question.  But it looks like SelLeft and SelWidth will do what I'm looking for.  I'll play around with it a bit later
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo