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!

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_" &...

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...

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...

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

all, i have a spreadsheet that takes data and turns it into a presentable report each time the report is run, the sheet is deleted and then recreated (to avoid wasted spreadsheet space) when recreated, a command button is entered to the sheet i have the code WRITE code into this new sheet there...

i would like to iterate thru all drop down boxes and text boxes in the current active userform i imagine the syntax is something like.. for each blahblah in userforms(activeuserform) blahblah.value = "" next blahblah does anyone know the exact syntax? thanks

in password protecting a sheet, what property must i access to unprotect an object so that it may be changed even if the remainder of the sheet is password protected?

hi all, what is the syntax for looping thru all checkboxes, dropdownlists, etc on a worksheet to change their locked property? (i want them to be unlocked? i tried the following for each checklock in oleobjects checklock.locked = false next checklock returned a type mismatch...please let me...

How can I place a range into an array ie. TestArray = range("TestRange") where test range is the range ("a1:z20") and then grab the first row of data with one line of code? ie. grab the contents of ("a1:z1") for manipulation (for this particular example i want to take this data and output it...

Is there a way to get around the fact that if you perform the Find function and the search text is not found, the program generates an error? i am attempting If IsError(range(CurrentHeaderRange).Find(RORS1Text).Column) = False Then but it is not working because the error msg still appears when...