Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.25 seconds.

  1. Re: Need to pass one variable to another form, but it's not passing the value.

    Most welcome


    Dave
  2. Re: Need to pass one variable to another form, but it's not passing the value.

    Hi,
    Move your public variable



    Public ClientNum As Long



    from your userform code page to a STANDARD module
  3. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    Search the net, examples are out there

    With template workbook you would not need to know if user(s) had their copies open if fact, they can leave them ope all day if want.
    The one you cannot...
  4. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    Its a similar subject line which a MOD may (or may not) have a view on.

    It it was a project I was doing I would connect template copies to a central database (Access ) but you can use another...
  5. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    You are not really meant to ask same question in two threads (I think)

    With multi users, having template copies of a workbook connected to a database (Access ideal or another workbook will work)...
  6. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    Is this question related to your latest thread: https://www.mrexcel.com/forum/excel-questions/1110236-if-userform-already-open-then-msg-box-open-saying-userform-use.html

    Short answer not easy...
  7. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    Most welcome - glad it all helped


    Dave
  8. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    follow carefully

    1 - BackUP your workbook

    2 - DELETE ALL THE CODE in your userforms code page

    3 - Place all following code in your userforms code page
  9. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    Have you inserted the Class Module & added the code in way I described in #post 21?

    Dave
  10. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    Without wishing to sound rude, really need to read all that I am posting





    Exactly that - did you copy ALL the code I posted to the Class Module?

    If so, confirm & I will provide the...
  11. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    Ok will do this in couple of steps

    Follow all instructions CAREFULLY

    1 - Make a BACKUP

    2 - From the VB Editor Insert > Class Module

    3 - Name the new module TextBoxClass <<< This is very...
  12. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    In my post I had this line



    which you have not followed

    You have two codes that need to be deleted
  13. Re: why it will error when i click my assigned macro to initialize userform ??

    Norrie - OP posted their project in another thread - It is very complex.

    Dave
  14. Re: why it will error when i click my assigned macro to initialize userform ??

    Try it this way & see if resolves



    Private Sub UserForm_Initialize()
    Dim ctrl As Control
    For Each ctrl In Me.Controls
    If TypeName(ctrl) = "MultiPage" Then ctrl.Value = 0
    ...
  15. Re: how to transfer datas in sheet to my radio button userform ??

    Hi,
    Yours is a very complex project & think my suggestions went much further to answer your original question.
    If I get a quiet moment will have a look but idea was for you take what I have done...
  16. Replies
    38
    Views
    482

    Re: Update cell after update from userform

    Hi
    try following

    Make a BACKUP of your workbook & add following codes to your forms code page



    Dim wRow As Long, wCol As Long
    Dim wsData As Worksheet
  17. Re: how to transfer datas in sheet to my radio button userform ??

    HI,
    you have created a very complex project which clearly you have spent a lot of time on. Fortunately, it looks like you have used naming conventions with indexes for your controls which allows the...
  18. Re: I want to control the order of cell selection during data entry.

    No worries, the tabbing solution was a slightly more complex approach for OPs who wanted to use the Tab key & arrow keys to move around a specified range.

    Appreciate you have been ably assisted by...
  19. Re: I want to control the order of cell selection during data entry.

    Just for information,
    SetOnKey is a code that formed part of a tabbing solution developed by myself & @Jerry Sullivan MVP on this forum sometime ago & would not likely assist you with this...
  20. Replies
    10
    Views
    186

    Re: Userform UPDATE record and date issue

    Hi,


    Generally speaking when managing dates it easier to use a date picker but the built-in one is not available to all versions – There are some good home brew userform version published you can...
  21. Replies
    10
    Views
    186

    Re: Userform UPDATE record and date issue

    Hi,
    data coming from a textbox is text & you should use a type conversion function as suggested by @Akuini to coerce to required data type.

    Glancing through your code not sure you really need to...
  22. Re: VBA auto refresh cell value in userform - textbox.

    Hi,
    see if linking the control to the range will do what you want

    replace your Initialize event code with following



    Private Sub UserForm_Initialize()
    Me.tbCPS.ControlSource =...
  23. Replies
    23
    Views
    1,020

    Re: help with a simple VBA code for excel form

    Glad resolved - many thanks for feedback

    Dave
  24. Replies
    2
    Views
    83

    Re: Prompt user if file save is cancelled

    Hi,
    try following & see if does what you want



    Dim FilePath As Variant


    Do
    FilePath = Application.GetSaveAsFilename(InitialFileName:=File121, FileFilter:="PDF Files (*.pdf), *.pdf",...
  25. Replies
    23
    Views
    1,020

    Re: help with a simple VBA code for excel form

    This section of the code coerces your textbox text values in to the appropriate data types (date, numeric) but the functions have their limitations & do not always perform as intended



    If...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4