Search:

Type: Posts; User: karolina1406; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    51

    Custom Print Pages VBA

    Hi All,

    I am trying to write VBA code for a CommandButton. I want the button to print in pdf a Dashboard from a tab in my worksheet called "Dashboard". It has 21 pages at the moment but I want to...
  2. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    You are a real star. Thank you very much for this. Al works very quick as as I needed...... thank you for your patience with me. I am VA self-taught and I only learn by using correct macros.
  3. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    sorry, I am more than a Blonde now. The code you provided works fine if I use it for One sheet only. I thought that I would have to copy and paste and alter this same code for sheet 2 - hence my long...
  4. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    Well, I have done something horribly wrong as it doesn't work at all! I have a command button which I want a code for. What is should then do is to hide all the rows with "0" in Column A in Sheet 1...
  5. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    great, that's fine... I tried to apply the same code for another tab (within this same command button) which is called "Pogramme_Plan" and the filtering (0,1) is in column A from row 9. I applied...
  6. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    sorry for being a Blonde but which part of this code does hide all the rows if in column C I have 0 "zero"?
  7. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    Already got this and its still slow :-( The only thing what speeds it up at the moment is if I switch off automatic calc however that then means that the command button needs to be pressed twice to...
  8. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    hi again :-)
    I was wondering if you know any tricks/hints/codes which would speed up my macro. I have applied above to a different model and it works perfectly fine other than it's very slow :-(
  9. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    that's great! It now works but I had to switch off this automatic calc.... Thank you very much for a help. Really useful learning
  10. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    sorry for confusion. I applied supporting measure in col C as exce formula: if($D$3=$e4 ,1,0). Hence I was filtering column C. Whole Command Button cod for John (CB1):

    Application.Calculation =...
  11. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    This same function. Basically, I want a user to open the spreadsheet and he/se will land on the page with 3 (for now) Command buttons: John, Anna, Chis. Tab2 is a table were I have a list of courses ...
  12. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    ok, just realised that I would have to click Required command button twice to relevant rows be hidden. Any idea why?
  13. Replies
    27
    Views
    671

    Re: Hide/unhide rows

    thank you for this. I applied this code to the command button A and B code which is in Tab1. but I specified that hidden rows must be in Tab 2. It works ok for the first "Click" e.g. when all the...
  14. Replies
    27
    Views
    671

    Hide/unhide rows

    hi All,
    I have a problem with the workbook I work on. In one Tab (Tab1) with command buttons (Names A,B,C and D). The second tab is a table with a data for A, B, C and D. I want to hide all rows...
  15. Replies
    1
    Views
    115

    VBA for Multiply Print Areas

    Can someone help me create a Command Button for creating a Print of 3 print areas which would then be printed on a separate page but fit the whole page? My printing areas are: E5:AF30, D37:AF70,...
  16. Replies
    6
    Views
    10,104

    Re: User Form Date Validation

    Fab! I really appreciate it!
  17. Replies
    6
    Views
    10,104

    Re: User Form Date Validation

    i have a similar problem with my User form. My current code is as below and anytime the user enters a date in a DateRaised_TX textbox, hte date is returned in the US format of mm/dd. Any ideas why?...
  18. Re: VBA to return numeric value instead of text from the UserForm

    btw, is there as easy way as this one to return a date in a dd-mmm-yy format? This is less of my issue with the form now however, if I can improve this as well - that would be great
  19. Re: VBA to return numeric value instead of text from the UserForm

    OMG! You're a star! it works perfectly!" Thank you very much!!!
  20. Re: VBA to return numeric value instead of text from the UserForm

    i have written below code to self populate the "Update existing risk" form based on the selected risk ID:

    Private Sub RiskID_Change()


    Dim Sh As Worksheet


    Set Sh =...
  21. Re: VBA to return numeric value instead of text from the UserForm

    thank you Steve... can i ask a silly question? (I am self-tutoring in VBA hence not everything is obvious to me). Should this code you gave me be entered on the Risk Register tab Excel Object or as...
  22. VBA to return numeric value instead of text from the UserForm

    Can someone help me with a User form? I created a form for a Risk Register with 2 command buttons: "Enter new Risk" and "Update existing risk". Both work fine however, when updating existing risk,...
  23. Replies
    2
    Views
    153

    Re: amending macro

    thank you for this... however, I get some error which says" Run-time error '424': object required.... :eeek:
  24. Replies
    2
    Views
    153

    amending macro

    hi,

    i used fab macro script to plot average on the chart. However, i noticed that the macro calculates an average taking into account elements with 0 values. Does anyone know how to amend below to...
  25. Re: add horizontal average line across excel chart

    hi,

    i used fab macro script to plot average on the chart. However, i noticed that the macro calculates an average taking into account elements with 0 values. Does anyone know how to amend below to...
Results 1 to 25 of 27
Page 1 of 2 1 2