+ Reply to Thread
Results 1 to 18 of 18

VBA_Help

Hybrid View

Nyay VBA_Help 06-16-2024, 11:57 AM
torachan Re: VBA_Help 06-16-2024, 12:21 PM
Nyay Re: VBA_Help 06-16-2024, 12:23 PM
Nyay Re: VBA_Help 06-16-2024, 10:01 PM
Nyay Re: VBA_Help 06-17-2024, 07:11 AM
kvsrinivasamurthy Re: VBA_Help 06-17-2024, 09:47 AM
Nyay Re: VBA_Help 06-17-2024, 09:53 AM
kvsrinivasamurthy Re: VBA_Help 06-17-2024, 10:22 AM
Nyay Re: VBA_Help 06-17-2024, 10:32 AM
kvsrinivasamurthy Re: VBA_Help 06-17-2024, 10:58 AM
6StringJazzer Re: VBA_Help 06-17-2024, 11:15 AM
Nyay Re: VBA_Help 06-17-2024, 11:50 AM
kvsrinivasamurthy Re: VBA_Help 06-17-2024, 12:08 PM
Nyay Re: VBA_Help 06-17-2024, 12:49 PM
Nyay Re: VBA_Help 06-18-2024, 01:40 PM
Nyay Re: VBA_Help 06-19-2024, 09:50 PM
6StringJazzer Re: VBA_Help 06-17-2024, 02:06 PM
Nyay Re: VBA_Help 06-17-2024, 02:19 PM
  1. #1
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: VBA_Help

    Do not use active X control buttons for assigning macro. Use only form control buttons.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  2. #2
    Registered User
    Join Date
    06-16-2024
    Location
    Dubai, UAE
    MS-Off Ver
    2019
    Posts
    31

    Re: VBA_Help

    Thanks, It work smoothly now.

    One more help I am attaching a file, the file has 4 sheet and 5th Sheet #SaveAs I have placed button to click SaveAs.
    I want to saveAs my current workbook, SaveAs in CSV by attaching the SaveAs Macro in the Button which is placed in 5th Sheet. I want only the 4 sheet and only
    data which is present, and not the information tag which I have placed to Add Month Name. Can you please help me with the code, First 4 sheet only columns till last row
    and not the information tag to do SaveAs in CSV format.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-16-2024
    Location
    Dubai, UAE
    MS-Off Ver
    2019
    Posts
    31

    Re: VBA_Help

    Can someone please look into Post #14 and help me with the solution.
    I have SaveAs Button in 5th Worksheet and want to saveAs only 4 worksheet till where the data is populated. Please help

  4. #4
    Registered User
    Join Date
    06-16-2024
    Location
    Dubai, UAE
    MS-Off Ver
    2019
    Posts
    31

    Re: VBA_Help

    Can someone please help me with the vba codes for query in Post #14

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,744

    Re: VBA_Help

    Quote Originally Posted by kvsrinivasamurthy View Post
    Do not use active X control buttons for assigning macro. Use only form control buttons.
    I have been using ActiveX buttons for about 20 years without issues. Why are you giving this rather absolute advice?
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  6. #6
    Registered User
    Join Date
    06-16-2024
    Location
    Dubai, UAE
    MS-Off Ver
    2019
    Posts
    31

    Re: VBA_Help

    Hey I tried Active X button, it was not function and tried form control and it worked. Can you please help me with my query in comment #14

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1