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
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...
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
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...
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
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.