Jump to content

Active Cell and MC Listboxes and Tables

Recommended Posts

I am working a lot with multi-column listboxes and tables lately and was wondering whether somebody new of a way to set cell colour (or other cell properties) for all 'body' cells at once.

If I use -2,-2 for ActiveCell I can set properties for all cells including row and column headers, but is there a way to select all cells except the headers?

Currently I read the properties for the headers, set the new properties for all cells, and then re-set the header properties.

Just looking for a simpler way :rolleyes:

Link to comment

Unfortunately -1,-1 only selects that empty cell in the column header row right above the row header column.

It's inelegant, but if you defer panel updates and change colors using {-2,-2}, and then select row header and column header successively to set them back to previous color, you shouldn't see the screen flicker and the user will not see the difference.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.