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: 34
Default Form Controls; setting properties based on cell values

I am currently setting properties for a number of form controls based on
conditions in a worksheet. I've labeled the form controls using numeric
values in the hopes that there may be some way to programmatically reference
them (as with INDIRECT) and reduce the amount of code.

Here is a sample of the code used so far (I've snipped out middle sections
to reduce size in this example):


If Range("T21").Value 0 Then
'Prep OtherEntry form
frmOtherEntry.fr1.Enabled = (Range("F21").Value 0)
frmOtherEntry.fr2.Enabled = (Range("G21").Value 0)
 
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
setting cell values based on a 3rd cell Bob Excel Worksheet Functions 4 March 30th 10 08:53 PM
Dynamically setting CELL COLORS based on TWO OTHER cell values Tom Excel Discussion (Misc queries) 3 February 22nd 09 07:34 PM
Setting properties of userform controls with VBA Dave[_52_] Excel Programming 1 December 22nd 04 09:27 PM
Setting form controls focus and enter key John T Ingato Excel Programming 1 October 6th 03 05:13 PM
Accessing the values of form controls on worksheets in Excel 2000 robbinma Excel Programming 2 August 28th 03 08:35 AM


All times are GMT +1. The time now is 01:40 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"