Search results for query: *

Hi All! Can anyone help me remember how to parse out a variable that contains dilimited and sub-delimited data? I thought either MID() or LEN() did that in VB, but I can't seem to get it to work. Something along the lines of this: Variable PATIENT contains the text "DOE,JOHN,C^34^M" What...

Hello all. I have a userform with a three comboboxes. The first two define the criteria for what's to be displayed in the third. The code that evaluates the states of the first two comboboxes resides in the Dropbuttonclick() event of the third. 'Below code is in a Do loop that loops...

Hi All. I've created a worksheet with multiple checkbox objects (from the forms toolbar) which are all in the same column, and are linked to particular rows. These checkboxes control hiding/unhiding of rows, and chart creation/deletion, and it is critical that their placement relative to...

Hi all! I’ve set up an Excel workbook with multiple checkboxes, all in the same column, which control chart creation/deletion and row hiding/unhiding. These checkboxes are from the Forms toolbar. (The kind that has a .linkedcell property) What I need to accomplish is to be able to sort the...

Hi All. Does anyone know if it's possible to pass a parameter to a macro within the assignment to a form control? (button, checkbox, etc.) When I try, Excel tells me the macro is "too complex to be assigned to an object". This would sure help me trim off some file-bloat in a project I have...

Hi All! This seems totally simple and obvious, but I can't seem to find it. Is there a VBA function, or even an Excel worksheet function, that will accept as an argument, Excel's numeric date representation (38058 for today's date 3/12/04) and return a real date? Basically, doing the exact...

Hi All. I had a months long project 100% finished, when I suddenly encountered "Run-time error '1004': Unable to set the Visible property of the CheckBoxes class." This is occuring on the line: ActiveSheet.CheckBoxes.Visible = False This line of code has worked beautifully up until now. I...

Hi All I've written a subroutine that assigns each checkbox on a sheet to one of three collections of my own making, which effectively groups them by purpose. This sub resides in Workboox_Open: Sub assign_collections() For i = 1 To ActiveSheet.CheckBoxes.Count Select Case...

Hi All In the project I'm developing, I've been making liberal use of this command "ActiveSheet.CheckBoxes(i)" to reference objects in the checkbox collection within looping constructs. I've even figured out how to assign these objects to collections of my own making: ____ Dim...

Hi All. I'm looking for a way to test, in an if statement, whether or not a cell contains text. I've done the same thing with dates, and empty cells using VBA.Isdate and VBA.Isempty, but I don't see a VBA.IsText or VBA.IsString function. Is there one, or is there another way? Thanks in...

Hi All. I'm trying to create a function that will place a chart directly below a given row on a worksheet. I've gotten close by using a for loop to load a variable (top) with the combined row height of all rows in a given range, then setting ActiveChart.Parent.top to that value...

Hi all! Is there a way to apply more than three conditional formats to a cell? In the conditional formatting dialog box, it only allows three. Anybody found a workaround? Thanks in advance. James

Hi all I am developing an excel tool which will have as many as 50 checkboxes that will trigger a macro to create a chart and position it just below the checkbox. That macro is all written and works, but I am currently having to assign a different Macro to each checkbox to call the...