1. M

    use excel while user form open

    I ma trying to set my project so that when my userform is open, I can still select and edit cells. I have tried setting the model to false and using vbmodeless but when I do that the form just blinks and goes away. Any ideas?
  2. W

    UserForm visibility and positioning

    Hello, I have a workbook that opens a userform as (vbModeless) on open and hides the window. Private Sub Workbook_open() Windows("Test").Visible = False Welcome.Show (vbModeless) End Sub The problem i am encountering is that this works only when there are other workbooks opened. If i open it...
  3. P

    Turning vbmodeless on/off for userform

    Hi everyone! I have a userform that I set up with multiple tabs. On one of these tabs, I'd like to be able to reference my userform and scroll simultaneously in my workbook. To achieve this, I know that I have to go into vbmodeless. The problem I'm running into is that one of my other tabs...
  4. P

    Is it possible to loop a userform more than once and disabling certain controls on the second loop

    Sub splitLot()<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;"> i = 0 ansSplit = 0 ans = MsgBox("Is this a split Lot?", vbQuestion + vbYesNo, "Split Lot") If ans = vbNo Then frmPackageYield.Show...
  5. R

    Class Module Triggered by multiple Target.Cell(1).Addresses

    Good day, I have a dashboard on a worksheet that has 50-60 numbers, when you click on any of those numbers a 30-day trend on a userform appears. In my excel vba naivety I inserted 50-60 userforms all with identical code to form the graph. Everything works but boy, what a waste! I have 50-60...
  6. R

    Show Activecell.value when in vbmodeless?

    I have a userform which contains a text box which is used for data entry purposes. The form is always open (i.e. running in vbmodeless) and I am trying to get the text box to display the 'active cell value' (using Text = ActiveCell.Value), However, whenever I move the cursor to a new cell, the...
  7. B


    i have a sequence of userforms used to input various codes into field. That all work great and go from flawlessly, until lately. I added vbmodeless to make cells selectable on one of the forms (everything still worked great. I then added a hyperlink to that same userform (opens up a different...
  8. T

    Modeless Userform using .Show vbModeless started triggering Type Mismatch Error 13

    Hello all, Thanks in advance for any suggestions! A little background: I've been tinkering with VBA for 3-4 years now starting with VBA for Dummies, moving on to Mr Walkenbach's Excel 2007:Power Programming with VBA, and have just recently gotten into Professional Excel Development: The...
  9. pedie

    vbModeless does not work why? Pls help!

    <TABLE style="WIDTH: 539pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=719 border=0><COLGROUP><COL style="WIDTH: 539pt; mso-width-source: userset; mso-width-alt: 26294" width=719><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8...
  10. T

    Editing Spreadsheet while UserForm open

    Hi All, I'm a newbie at excel VBA and I am attemtpting to use a UserForm (with hidden excel) to gather data from a client and give the client a button option to view/edit their excel spreadsheet data. I tried researching the web for solutions to my problem and found info on vbmodeless...

Some videos you may like

This Week's Hot Topics