Search:

Type: Posts; User: My Aswer Is This; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.44 seconds.

  1. Re: Move text in cells via Checkbox tick

    I think it would be a lot easier for you to double click on a cell to perform the task your asking for

    If you want to use a Checkbox then you would have to create 20 Checkboxes and assign code to...
  2. Replies
    1
    Views
    92

    Re: Picture button VBA

    Is SelName the name of the sheet you want to go to? We call them sheets not Pages.

    selName = Mid(Application.Caller, 1, InStr(1, Application.Caller, "_") -
  3. Re: Load data from worksheet into Userform

    I suspect you do not have the sheet named exactly like this.
    Or maybe the sheet is protected

    Or Your Textbox does not have that exact name

    Everything must be exact.
  4. Re: Load data from worksheet into Userform

    And you have this code in a Button on your Useerform.

    Why not show me all the code like.

    Private Sub CommandButton1_Click()
    And you code here
    End Sub
  5. Re: Load data from worksheet into Userform

    I tried this line of code and it worked for me:

    Data1.Value = Sheets("Data Validation").Range("X2").Value

    Do you have a TextBox on your Userform Named Data1 ??
    Do you have a sheet named Data...
  6. Re: Automatically copy rows from one spreadsheet to another

    The term Spreadsheet has been eliminated from Excel terminology.

    Excel now uses the terms:
    Workbook and Worksheet.

    So you said:

    I have a series of spreadsheets in their own workbooks

    And...
  7. Re: Finding duplicated values in a cell with userform

    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  8. Re: Finding duplicated values in a cell with userform

    Try this:

    Private Sub CommandButton1_Click()
    'Modified 6/13/2019 4:30:57 AM EDT
    Dim ws As Worksheet
    Set ws = Worksheets("Sheet1")
    Dim Lastrowa As Long
    Lastrowa = ws.Cells(Rows.Count,...
  9. Re: Finding duplicated values in a cell with userform

    Show us the script your using to enter the values into the sheet.
  10. Replies
    3
    Views
    112

    re: VBA Insert rows Offset

    In your image 4/17/2019 was first in column 6 but after insert was in column 5
  11. Replies
    3
    Views
    112

    re: VBA Insert rows Offset

    I am not able to see what you want.

    You said insert Rows.

    But normally when you insert a row the new row will be empty.

    But that is not the case in your example.

    You may be inserting...
  12. Re: Copy sheet with popup message asking to name the new copied sheet

    Well I can get the cancel thing to work.

    But your saying if the users performs any error you never want to see a Message Popup telling him he made a error.

    You just want the Inputbox to pop...
  13. Re: Copy sheet with popup message asking to name the new copied sheet

    You said:

    Pretty standard process when using any PC, cancel...script ends you don't get warnings.

    OK if I'm trying to do something and script just ends after doing nothing how do I know what I...
  14. Re: Copy sheet with popup message asking to name the new copied sheet

    After testing my last script I find it will not work.

    I really have no answer for you.

    Your wanting if the user enters a improper name or no value or clicks Cancel button to get no warning but...
  15. Re: Copy sheet with popup message asking to name the new copied sheet

    Try this:
    The user will get no warning.

    He will now know nothing happened when he entered a Improper name or a previously entered name.
    All he will know is nothing happened:


    Sub...
  16. Replies
    18
    Views
    224

    Re: Textbox value to cell

    In post 4 you said:

    I figure it out

    So I suggest you just continue using your code which you said worked.

    My script assumed you wanted all textbox values entered at the same time.
  17. Replies
    18
    Views
    224

    Re: Textbox value to cell

    I really do not see why my script needs to be modified. The script does exactly what the user asked for in post 1.
  18. Replies
    18
    Views
    224

    Re: Textbox value to cell

    Your original question was very simple:
    You said:


    textbox 1 to cell P7
    textbox 2 to cell P8

    and so on to Textbox 16

    And that is exactly what my script does.
  19. Replies
    18
    Views
    224

    Re: Textbox value to cell

    Well you said:

    Row P

    There is no Row P

    There is a column P

    And you said:
  20. Re: Copy sheet with popup message asking to name the new copied sheet

    That is because if you do not enter anything or click cancel you have not entered a proper sheet name.

    The warning says you have entered a improper name or have already used that name.

    So...
  21. Re: Copy sheet with popup message asking to name the new copied sheet

    Try code in Post 13
  22. Re: Copy sheet with popup message asking to name the new copied sheet

    Well maybe I do know how:

    Try this:

    Sub Copy_Master()
    'Modified 6/12/2019 1:45:38 AM EDT
    Application.ScreenUpdating = False
    G:
    On Error GoTo M
    Dim ans As String
  23. Re: Copy sheet with popup message asking to name the new copied sheet

    This is beyond my knowledgebase.

    Your asking for the script to completely start over again with no interaction from you.
    I will continue to monitor this thread to see what I can learn.
  24. Re: Copy sheet with popup message asking to name the new copied sheet

    Well we are copying the sheet so all the row heights should be the same.

    As far as your new requests now about what if this happens or that happens then Please rewrite your original post and spell...
  25. Re: Copy sheet with popup message asking to name the new copied sheet

    Try this:

    Sub Copy_Master()
    'Modified 6/12/2019 12:36:16 AM EDT
    Application.ScreenUpdating = False
    On Error GoTo M
    Dim ans As String
    ans = InputBox("The New sheet you want named", "Enter new...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4