Search results for query: *

Thanks, it was the Shape, after changing it no further problems. Greatly appreciated Jochen

As I said, the code works fine up to the point where any Combo Box is active and the row that it is in gets hidden. I included the Select option the activate a cell and then hide the rows, but that does not work. Hope this makes sense Jochen

Here is the whole code for one input sheet Public Sub EXT_Activate_Cell() Sheets("External Footing").Range("IPEXTWidth").Select End Sub Public Sub CBEXTPilingGeoAdd_click() Sheets("Data").Range("EXTPilingGeoStandard") = False EXT_Geotech_Adjust_Case1 End Sub Public Sub...

I think we are talking two different things here, I have done exactly what combo has suggested, the full code has not been displayed as it just caters for load cases and when rows need to be hidden or not. The above code is (one else function) for hiding most rows and setting up a button to add...

Now I am confused (BTW English is not my first language) The problem still stands: Either the boxes stay in their appropriate cells and excel crashes, or the cells slide down and excel works fine (in this case, the row with the active box is not hidden, as the box is not anchored there). Now...

Re Skip: Yes that is correct. What I see at the moment is my control sliding down the page when the rows get hidden and staying in this position relative to the cell the now occupy once unhidden. (Using anything but the move and size properties) Re Combo: This is essentially what I have done...

Problem is, the top properties are variables according to which rows are hidden. The only way it actually works is by leaving the properties with Move and size and setting the placement to 2 However, that is the case where excel crashes :-) Might have to find another way of dealing with this...

Hi Skip, got a new problem now, the combo boxes further down are not staying in their row anymore. The rows are changing in a random pattern, so there are only fixed locations for the topmost box any ideas what I can do? Jochen

That solved the problem of crashing, thanks. However, I now have a visible combo box that stays until you refresh excel. That should be solved more easily though :-) Thanks again Jochen

Problem with that is the amount of text and so on that will distract the user in those rows will need to be hidden as well. Hiding the rows results in a nice compact input sheet that adjusts itself to what is required and in the order it is required. (and it is not a single case in this...

Sorry, I thought the word Combo Box was what you were looking for, its a Control Toolbox Jochen

to replicate the problem: step one - insert combo box with two or more options step two - select combo box and change value (leave selected) step three - hide row step four - watch your excel crash This looks like an Excel problem to me. Without code all you have to do is selecting a...

The code as i said works fine without the active combo box CBEXTPilingAdd.Visible = True CBEXTPilingRemove.Visible = False CBEXTPilingGeoAdd.Visible = False CBEXTPilingGeoRemove.Visible = False Shapes("CBEXTPileMassDia").Visible = False Shapes("CBEXTPileDia").Visible = False...

Hi there, I have the following problem. I have a macro that hides certain lines to allow easier input when those lines are not required. Part of these lines are combo boxes. It all works fine until a special case arises: The combo box has been changed and the button to initiate the hide...