Search results for query: *

i have a workbook with a bunch of pictures they are either being labeled by excel as freeform, object or picture how can i cycle through these and delete them without hitting control objects (ie. dropdowns) is there a simple way? thanks

Does anyone no how to access the "match entire cell contents" property of a workbook? its a boolean. Thanks!

seems this works QueryArray(GenericLoop, GenericLoopB) = Sheet1.Shapes(QueryNameArray(GenericLoopB) & "_" & GenericLoop).OLEFormat.Object.Object.Value

guys, unfortunately this code does not work...it requires that i pull a property of the shape to set it to a value in the array how can i do this so that i can get the value contained in the drop down? the shape doesnt have a text or value property thanks!

i am wondering whether there is a way for a control to be accessed via a string ie. i have a drop down called condition1_1. these increment up to condition1_4 is there a way to access all 4 and assign them via a property? for x = 1 to 4 Set testarray(x)= VBAProject(Sheet1 "Condition1_" &...

im booing your answer i have tried locating this info in the book i have (walkenbach). but it is not helpful enough if i can get a bit of help starting out im sure i can figure it out it doesnt seem too tough, but i just need to know how to assign the properties and then be able to access them...

booooooooooooooo

if i want to create a simple object with the followuing properties: obj.text1 = "Single" obj.value1= .01 obj.value2 = 10 how would i go about doing this? (where obj could be any name and i could create an infinite number of custom characteristics thanks!

I have created a drop down box. (control box) When i try to "additem" with this object, it returns "permission denied" I have never seen this before Can someone please offer some advice as to why this is happening? thanks

how do i get the following to function properly? in excel, =max(len(range)) functions by turning the formula into an array. what is the syntax for doing this within excel? i am trying to set test = to the outcome test = {application.worksheetfunction.max(len(range))} but it is not working...

thank you. do i need to add the name of hte module to that string of code? i am getting an "object required" error message upon execution when i place that line of code into the project

hey all, how can i delete a module from within the code? i am trying vba.project.arrayname but there doenst seem to be any deletion functionality thanks

i am wondering how i can create a click event on a button control object from an independent set of code the button is pointint to a subroutine titled "SmoothMech" and I want code from within a module to access either "smoothmech" itself (which is a public sub and in a worksheet) thanks for...

All, Is there a way to have a custom list, for example {Apple, Berry, Cherry, Sam} and have corresponding cells that, when typed into, automatically populate with contents from the custom list? For example, the user can type an "a" into cell A1, and the cell will allow the option to fill with...

how can i create a custom function that does something like the following: function(interpolate) will take a range, interpolate values in the range, and output them as an array ie. 1 blank blank 4 would produce 1 2 3 4

All, I have a spreadsheet in which I use some somewhat time consuming custom functions... couple of questions a) are there particular methods for optimizing custom functions? those that microsoft provides seem to run exponentially faster and i am wondering if there is any way to at least...

all, wondering if anyone knows how excel can capture a "missing" argument WITHOUT required a conditional ismissing function in the subsequent code can the argument be defined in such a way as to catch missing arguments and provide them default values or at least make it so that the missing...

thanks for all your help guys

does anyone know a simple means of developing help for functinos? i want to allow the user to know what should be input in each argument i cannot seem to find any good info on this specific topic for example rectanglearea(height, width) i want user to see in the function dialog box when...

is there any way for a function to output information to the spreadsheet on which it is activated? i am trying to perform this but the function fails at that point in the code