LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 414
Default User form bug

I've created a user form.
I have one last "bug" that I need resolved.

For further explanation, when we place a worksheet function in a worksheet,
when a range, or cell is chosen, it's "highlighted" by a colored outline of a
box for that range of cells. If one chooses a series of individual cells,
there are multiple colored boxes.

This is what I was looking for, so that the user could keep clear what
they'd chosen while going through the user form.

Is there a means that I can have these colored outlines, on the worksheet
while I'm selecting ranges for each of my RefEdit elements? If so, how? Is
this located in the properties box of each RefEdit element?

I have looked through the properties of RefEdit, and found HideSelection. I
set it to false, and this does not resolve my issue.



Again-- thank you for your helps.
Best,
SteveB.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date field in user form & Loading a user form on opening workbook Balan Excel Programming 1 May 24th 08 03:40 PM
Call user form from ThisWorkbook; close file if form closed XP Excel Programming 2 July 20th 07 07:04 PM
Automatically add a textbox to a user form based on user requireme Brite Excel Programming 4 April 7th 07 11:37 PM
User form ComboBox Items: Remember user entries? [email protected] Excel Programming 0 March 29th 07 06:41 PM
How to: User Form to assign a user defined range to a macro variab TrevTrav Excel Programming 1 March 22nd 05 07:57 PM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"