Search results for query: *

Skip, Thank you very much. That worked nicely. I guess I'd imagined using MID or LEN for this. I've never heard of this function, but it works perfectly. 1 * 2 U

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

Mintjulep, You are the best. That works perfectly. Don't know why I didn't think of it myself. Thanks a million.

Hi Mintjulep Actually, I'm already doing that with one and two. But the user won't necessarily be leaving those boxes every time. I need to make it so they can click on the third combobox multiple times without the list doubling, then tripling, etc. Thanks.

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 Skip. I totally agree. That's something I've learned during the course of this project. Unfortunately, I'm way too far down the road of using these form controls to turn back. I'll undoubtedly use the other approach on my next project, but this one has already been deployed, is well-liked...

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

PH, Thank you SO MUCH!! That was exactly what I needed. All I have to do is sort the worksheet, then... ActiveSheet.CheckBoxes(a).Linkedcell = "B" & ActiveSheet.CheckBoxes(a).TopLeftCell.row - 1 ...to reassign the cell to the left of the object. Now if I can just get Excel to position the...

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

Fumei Yeah. That's always a better approach. Unfortunately, this particular project won't allow it because I'm refining an existing tool that's based on direct interaction with the spreadsheet. I had to stick to that approach because people are used to it. So I gather that what I was...

I'm actually working with Excel. These are checkboxes from the forms toolbar. I use Excel so much, sometimes I forget that VBA works with other applications. Sorry for the lack of detail. Thanks.

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

Thanks Skip. I actually ended up solving this particular problem with a custom format, but your solution works perfectly. 1 * to you.

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

Tony The tool I'm creating is a project tracking list. Each project has two checkboxes. One to show a chart, and one to expand rows of text notes. I wrote all the macros in advance, but when I add a project, I add two checkboxes, and assign the predefined macros to them. With that said, I...

Thanks, Krinid That's a good point, and something I'll definitely check out. Let me clarify my poorly worded post. The project was only completed yesterday, but I'd been working on it for months. The mishap with the .visible property happened while I was loading it up with live data, but not...

Hi PH Yes. I generally turn off screen updating on most macros, which does speed things up a lot. Unfortunately, this particular one still takes a long time to run. When I could hide all of the controls with one command, it took no time at all. It's the loop that takes forever. Thanks for...

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

I've read a little about keys, but have no idea how to assign one. Any help on that would be great. Thanks. James M.

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