vbmodeless

  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

    userform

    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

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top