+ Reply to Thread
Results 1 to 17 of 17

How to enable and disable when the user clicked the rectangle as button?

  1. #1
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    88

    How to enable and disable when the user clicked the rectangle as button?

    Hi,

    I have a few questions based on my sample shipping in excel.

    Could someone guide and check the VBA coding in which:-
    The Column of Shipping Charges - Extra Charges (cell C27) :
    Steps:
    1) Once the user select the extra charges at the Shipping Charges , the user is able to choose either "custom clearance" or "custom duty" at the extra charges column.
    2) Then the user has to checklist their goods by selecting the Yes or No at the Shipping Checklist column.

    Take note that "no extra charges" and "no installment" at the shipping charges column are not allowed to select the rest of the column but itself and how should i create a pop up message you are not allowed to select the Extra Charges and Shipping Checklist Column.

    Kindly assist with many thanks.

    Excel Attached included.
    Attached Files Attached Files
    Last edited by fgfgicare; 08-14-2020 at 04:22 AM. Reason: title

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: VBA on Buttons

    the title of your question is "buttons". you are giving steps of what you want to do. but are you wanting to have each step (task) that the user does associated with pressing a button for each? buttons can have VBA macros assigned to them. but they have to be SUBs (subroutines), I believe. your question was a little bit vague. there are things you can do inside the interface (on the worksheet, not in code) to manipulate what the user does and make things happen after a user performs some action, but code is probably easier to control their actions.

  3. #3
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: VBA on Buttons

    I think you can execute what you want with Multi-Level Drop-Down, and you must change your thread title because it not gives exactly what you want

  4. #4
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    88

    Re: VBA on Buttons

    Hi vba_php,

    Thanks for your comment. I hope the title is okay to understand.

  5. #5
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    88

    Re: VBA on Buttons

    Hi Mazan2010,

    I have changed my thread title that relates to my questions.

    Thanks for your suggestions. This form needs a certain click like rather than a multi-level dropdown.

  6. #6
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: VBA on Buttons

    Quote Originally Posted by fgfgicare View Post
    Hi vba_php,

    Thanks for your comment. I hope the title is okay to understand.
    it is fine to understand. but your last post did not provide any additional info about what you need. are you asking for the code to be written for you?

  7. #7
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    88

    Re: VBA on Buttons

    Hi vba_php,

    Thanks for your reply.

    Could you check the coding that I provided at the Visual Basic? I have no idea where is my missing code especially on the column C:D, when I select the Extra Charges button, it must shows the selection either custom clearance or custom duty. Then, I can able to select at the Shipping Checklist column but none of it can select.
    You may beautify it.

    Let me know if there is questions.
    Last edited by fgfgicare; 08-14-2020 at 09:31 AM.

  8. #8
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to enable and disable when the user clicked the rectangle as button?

    Are you asking us to look at the code in the file that you uploaded in your original message?

  9. #9
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    88

    Re: How to enable and disable when the user clicked the rectangle as button?

    Yes, it is possible or otherwise?

  10. #10
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to enable and disable when the user clicked the rectangle as button?

    Oh I'm sure it's possible your file was not that complicated. But I can't do it at the moment but I can certainly look at it in a little while but if someone else has the time maybe they can look at it too. I will take a look for you in a little bit if no one else gets back to you

  11. #11
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: How to enable and disable when the user clicked the rectangle as button?

    Dear fgfgicare
    please check attached file with dependent dropdown as another Idea, if this is okay for you till someone can solve your code
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    88

    Re: How to enable and disable when the user clicked the rectangle as button?

    Dear mazan2010,

    Thanks for your another idea.

    I would be very appreciated if you can solve my current queries in number #1 as my management need this form to print out as a document.
    That's why I am searching for a solution.

    I hope someone will look into this as I really need your expert.

    Thank you very much for your time and effort.

    Appreciated the most.

  13. #13
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to enable and disable when the user clicked the rectangle as button?

    Quote Originally Posted by fgfgicare View Post
    Dear mazan2010,my management need this form to print out as a document.
    I will take a look later on today if someone else doesn't post here. But one thing, have you considered telling the management personnel in your company that the request my not be possible to fulfill? I've talked to so many programmers in more than 20 years that are scared to death to their managers that they are making tough and/or impossible requests and make alternative suggestions. I think this happens either because they are not knowledgeable about their tools and are not confident or they don't want to guide management properly as to what is possible and what isn't because they are not authorities in their companies.

    I'm not saying that you are not knowledgeable about Excel, I'm just saying that you might want to consider this as a tactic to help your management gain a better understanding of the tools you are working with to help them out. I consult all the time and I get many questions from people that are almost impossible to answer because some of them want software products to do things that programming languages can't even do because the are not well enough developed yet.

  14. #14
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    88

    Re: How to enable and disable when the user clicked the rectangle as button?

    Quote Originally Posted by vba_php View Post
    I will take a look later on today if someone else doesn't post here. But one thing, have you considered telling the management personnel in your company that the request my not be possible to fulfill? I've talked to so many programmers in more than 20 years that are scared to death to their managers that they are making tough and/or impossible requests and make alternative suggestions. I think this happens either because they are not knowledgeable about their tools and are not confident or they don't want to guide management properly as to what is possible and what isn't because they are not authorities in their companies.

    I'm not saying that you are not knowledgeable about Excel, I'm just saying that you might want to consider this as a tactic to help your management gain a better understanding of the tools you are working with to help them out. I consult all the time and I get many questions from people that are almost impossible to answer because some of them want software products to do things that programming languages can't even do because the are not well enough developed yet.
    Dear vba_php,
    Thanks of for your honesty advise. This make me to think a few hours before writing this to you.

    May I ask , if someone including you is not posting here today, should I consider this as impossible to fulfill?
    If yes, please comment to me here so that, I will have to use the mazan2010's idea in an excel way for my submission as the dateline is just around the corner.

    Appreciate the most.

  15. #15
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to enable and disable when the user clicked the rectangle as button?

    hello fg,

    I'm not sure I'm understand this by you:
    Quote Originally Posted by fgfgicare View Post
    May I ask , if someone including you is not posting here today, should I consider this as impossible to fulfill?
    are you asking if I have time to try and help you solve the issue? and if not, you are considering using mazan's solution? as I said, I will take a look later on today (maybe a few hours from now) and see if the original issue can be solved since I've tried to help you since the beginning,

  16. #16
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    88

    Re: How to enable and disable when the user clicked the rectangle as button?

    Dear vba_php,

    Sure, I will wait for your answer.

  17. #17
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: How to enable and disable when the user clicked the rectangle as button?

    I'm off to bed. but I think you are going about this all wrong, fg. your file has no user interaction to it. you can use FORMS, BUTTONS and all types of other controls with excel. the sample that I am giving you is showing you just a simple thing that you can do. this is not 100% what you are looking for, because I still can't understand what you're talking about. this example if meant to show you what I think you want as some sort of end result.. take a look....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Validation and Command Buttons or Form Buttons
    By rededdie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-20-2019, 03:48 PM
  2. Radio Buttons only working on some computers, Buttons are being renamed
    By branas7180 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 12:03 PM
  3. Macros with buttons, spin buttons, scroll buttons, etc.
    By qqbbppdd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2013, 09:34 AM
  4. enable certain combo buttons based on user selected option buttons
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2013, 06:43 AM
  5. How to insert and user of Buttons, Radio buttons, check boxes in excel sheet.
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 02:52 AM
  6. How to insert Buttons, radio buttons and check boxes in Excel
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2013, 08:13 AM
  7. How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?
    By mickwooduclan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 10:01 AM

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