Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.24 seconds.

  1. Re: Userform VBA option button get selected option

    Not as far as I am aware unless another here reading this thread can offer further insight.

    All suggestions posted are workarounds & any one may offer something that will go a little way in...
  2. Re: Userform VBA option button get selected option

    Hi,
    If you just want to establish the status for a named group of controls (True / False) you could as an idea, create a function

    See if following will do what you want



    Function...
  3. Replies
    11
    Views
    239

    Re: userform editing & listbox issue

    Hi,
    Finally found moment to look at your code & made some changes

    Make backup of your workbook & replace ALL code in your form with following:





    Option Explicit
  4. Re: Help with VBA issue using command button on separate page

    Normally, you test in the Range.Find function but you have a search box so can test for no match there & give user opportunity to enter another value



    Sub SearchForString()
    Dim...
  5. Replies
    11
    Views
    239

    Re: userform editing & listbox issue

    for those that may be able to assist, some sample data included that relates to issues you are having would also be very helpful

    Dave
  6. Replies
    11
    Views
    239

    Re: userform editing & listbox issue

    As yours is a large project its sometimes difficult to test code posted - may get more responses if you could place copy of your workbook with sample data in a dropbox & provide link to it here.
    ...
  7. Re: Help with VBA issue using command button on separate page

    You currently copy the EntireRow so to place copied data to Range that is not the same size, you will need to size the data you are copying

    something like this

    change this line


    ...
  8. Thread: Stock Control

    by dmt32
    Replies
    1
    Views
    81

    Re: Stock Control

    Hi,
    welcome to forum

    Hi,
    What you want to do possibly can be done but likely to be a lot of work & still may not fully offer functionality you may have in mind

    Have a read of this thread from...
  9. Re: Help with VBA issue using command button on separate page

    The Columns reference (shown in bold) does not have a workbook and worksheet associated with it. Without an explicit reference, Columns refers to the ActiveSheet by default. So your code may fail...
  10. Replies
    6
    Views
    93

    Re: Code lags when run

    Hi

    try



    Private Sub Worksheet_Change(ByVal Target As Range)
    On Error GoTo myerror
    If Not Intersect(Target, Range("D5:D35")) Is Nothing Then
    Application.EnableEvents = False
  11. Thread: find function

    by dmt32
    Replies
    3
    Views
    24

    Re: find function

    welcome - thanks for feedback

    Dave
  12. Thread: find function

    by dmt32
    Replies
    3
    Views
    24

    Re: find function

    Hi try



    Set SearchRange = Range("A18:A" & LRow).Find(CbName, LookIn:=xlFormulas, LookAt:=xlWhole)


    Dave
  13. Replies
    4
    Views
    64

    Re: Workbook is Nothing

    Hi,
    you have declared you object variables Public and maybe they are holding a previous value?



    Public AWorkbook As Workbook
    Public BWorkbook As Workbook
    Public ASheet As Worksheet
    Sub...
  14. Re: Help with VBA issue using command button on separate page

    Hi,
    welcome to forum

    See if this update to your code helps



    Sub SearchForString()
    Dim LSearchValue As String
    Dim RefCount As Long
  15. Re: Excel VBA User form validation of date to exclude Sat, Sun and Holidays

    Hi,
    you can use both those functions in VBA to test your calendar control or textbox for entered value


    untested but hopefully, gives you something to work with



    Private Sub OK_Click()
    ...
  16. Replies
    12
    Views
    547

    Re: help with a simple VBA code for excel form

    Hi bit short of time as on granddad duties today - its a bit crude but give this tweak a try and see if works ok for you


    replace this line



    With Me.Controls("TextBox" & i)
  17. Replies
    12
    Views
    547

    Re: help with a simple VBA code for excel form

    Hi,
    what is your combox name? Counting 13 controls, where in the sequence of does it need to be placed?

    Dave
  18. Replies
    1
    Views
    66

    Re: Multiple User Auto Update

    Hi,
    welcome to forum
    If your users have access to your workbook over corporate network then as an idea, you could add button to their worksheet together with little code, this will allow then to...
  19. Replies
    12
    Views
    547

    Re: help with a simple VBA code for excel form

    Hi,
    see if this update to your code helps



    Private Sub CommandButton1_Click()
    Dim wsKPI As Worksheet
    Dim lr As Long
    Dim i As Integer
  20. Replies
    14
    Views
    209

    Re: VBA Extract Data and Paste to another sheet

    Fluff,
    I liked your suggestion better so did not post but just a thought, could it be case sensitive issue maybe?

    Dave
  21. Thread: userform on VBA

    by dmt32
    Replies
    5
    Views
    184

    Re: userform on VBA

    Hi,
    untested but see if this update to your code helps



    Private Sub CommandButton1_Click()
    Dim nextrow As Range
    Dim X As Integer
    Dim arr() As Variant
  22. Replies
    3
    Views
    105

    Re: Constantly Changing Password Macro

    You say you want to unlock whatever the password is but if is your real intention I think you will find this to be regarded as "cracking" which we are not allowed to discuss here -

    You need to...
  23. Replies
    4
    Views
    88

    Re: Saving .xlsm worksheet as .xls workbook

    Hi welcome to forum

    At glance code looks ok but you could also add some error handling just in case things go wrong




    Sub SaveAs(ByVal grpID As String)
    Dim fName As String, fPath As...
  24. Re: Using Macros, Hide (with password) and Unhide multiple worksheets

    As the code has a parameter you have to type it in when assigning to a control.




    'SheetsVisibility xlSheetVeryHidden'



    or
  25. Re: Using Macros, Hide (with password) and Unhide multiple worksheets

    Mine is a straightforward marco that meets your original request



    Code provided performs both functions (hidden & unhidden) whilst keeping certain sheets visible

    I Initially provided an...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4