Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tobin1

    set variable range to fill combo box on another sheet

    Howdy PHV, OOPS my fault [dazed] . The tab name for the second sheet is not Sheet2. When I use the tab name it works perfect even in a click event. Thanks again - you were very helpful Tobin Sparks www.nov.com
  2. tobin1

    set variable range to fill combo box on another sheet

    Howdy, Thanks again PHV for your interesting suggestion. Maybe we have different versions of Excel. I'm still using 2003. I tried all of the following: Didn't work even in Sub Worksheet_Activate() Sheet1.OLEObjects("cbx_RevLookUp").ListFillRange = "Sheet2!Y102:Y108" Didn't work even in Sub...
  3. tobin1

    set variable range to fill combo box on another sheet

    Thanks PHV for your response. Interesting try but still can't make it work. Apparently I need to get the range values as string data type not just an empty "string". Any other suggestions? Tobin Sparks www.nov.com
  4. tobin1

    set variable range to fill combo box on another sheet

    Howdy, I'm having difficulty doing something that seems like it should be very simple. Private Sub cbx_RevLookUp_DropButtonClick() Dim ListRng As String Application.ScreenUpdating = False ListRng = Sheet2.Range("Y102:Y108") Sheet1.cbx_RevLookUp.ListFillRange = ListRng End Sub I have a...
  5. tobin1

    Method or Syntax for Controls

    feherke, Thanks again for the pointer to the Scripting Framework. I finally was able to read the section on the OpenOffice.org API. I finished the examples (with a little existing VB knowledge) and was able to find exactly what I was looking for. Thanks Tobin Sparks www.nov.com
  6. tobin1

    Method or Syntax for Controls

    Thank you for your response. That will take me quite some time to read through, but, I'm sure there will be helpful information in the book. I was hoping for something simpler, maybe even a sample macro. Thanks Again Tobin Sparks www.nov.com
  7. tobin1

    Method or Syntax for Controls

    Howdy, I'm new to the OO API. I'm trying to learn a little and make a macro. Is it possible to use a button, radio button or check box to make changes to other controls? For example, when a button is clicked other buttons are changed thru code to enabled, disabled or other effects. If so, can...

Part and Inventory Search

Back
Top