Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / November 2006

Tip: Looking for answers? Try searching our database.

List Box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steven - 24 Nov 2006 19:03 GMT
I have  2 questions about ListBoxes:

Question 1)
Why with the following code does the LisBox1 always display in Design Mode?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   If ActiveCell.Column = 4 Then
       ActiveSheet.Shapes("ListBox1").Visible = -1
       ActiveSheet.Shapes("ListBox1").Select
   Else
       ActiveSheet.Shapes("ListBox1").Visible = 0
   End If
End Sub

Question 2)
Will the list box always show in the same spot on the screen regardless of
which line on the worksheet I am on.  For example.  If I am on row 10 and the
ListBox shows in the middle of the screen then if I am on row 100 will the
ListBox still show in the same postion on the screen when I click on a cell
in column D.

Thank you for your help.

Steven
XOR - 27 Nov 2006 01:46 GMT
you cannot hide items when in design mode. they will be hidden at run time
though.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.