Excel VBA - Use an existing string in called sub -


I already ask for so much apologies

I am halfway through a userform and in Excel I'm trying to make some big cuts with my code using the call - I have 12 buttons which all do the same thing, the only difference is that each button is subtly dependent on the sub-button caption is . My problem is that I do not already understand a way to use the string declared in the button sub, then use it in the sub-sub I know that you can do this, but my Google skills do not fail me (

Can anyone show me how to do this? Hopefully everyone understands ...

My code has a very small snippet , But you get jist: 

  public subcommand Tone 4_click () String name as the dim name = CommandButton4. Caption call sort 1 and all`

and another (tried to do it as a function for testing and error ) 

  Public Sub-order 1 (name as string) Label11 caption = name sheet (name).  << code>   
 
 
 You are   passing an argument   for the other substrin or function. First of a string There is a sample of: - 
 
  function leftOne (string as string) in the form of a string LeftOne = Left (StrSample, 1) Termination function  
 
 A BOVE function can be used within another function or suburban areas if you meet its requirement: Argument field of the  StrSample  function By declaring  StrSample as String , you get the original The form requires that any call for this be  string must be passed  
 
 the string as the full line  LeftOne (string as the string) < / Code> can be read: "I am doing LeftOne function. Give me a string and I'll 'return' to a string after doing something with it. Note that the name  StrSample  is an arbitrary name. 
 
 Anyway, the above is as simple to call: 
 
  SubMsgInABox () Dim StrToFeed as String StuffFeed = "BK 201" MSBBC Lieuten (Stratophid) 'Return B & Sbs'  
 
 In your example, if you select  Name < Code> want to pass sort 1 , your effort is absolutely correct. 
 
 Let us know that it helps.

Comments

Post a Comment

Popular posts from this blog

c# - Reactive Extensions ControlScheduler -

Well, I'm using Reactive Extension Event Handler to handle my app events, I run the headlines on the Yuri thread. I also use ControlSubular for However, recently I am getting cross thread exception despite using control scheduler and I do not know what the problem is. Code: Observable.FromEventPattern & Lt; String & gt; (CC, "UiAlertMessage", New Control Session ()) Subscribe (_ = & gt; {Alert Control. (Show this language, title, _.EventArgs.UppercaseFirst ());}); The new control scheduler (this) is not to run the code on the UI control thread, so I do not get cross threading exceptions? you should do Observable.FromEventPattern & lt; String & gt; (CC, "UiAlertMessage"). AboveOption (this). Subscribe (_ = & gt; {Alert Control. (Show this language, Titles, _.EventArgs.UppercaseFirst ());}); This is the standard way of sending a scheduler related to specific controls. Passing control scheduler as you have got subsc...
Read more

scala - Play Framework - how to bind form to a session field -

Is there any way, I can get some parameters from the header, cookies (log in userId in my case) , And then apply it in a form which I know who will deposit the ticket? SupportForm supportForm: form [supportTicket] = form (mapping ("question" -> text, "priority" -> text) (apply support ticket. (HelpText.update) What are the good practices here? What is the call to apply the request, when I can use it (and also a good practice?) Edit An issue, absolutely deceiving anyone if I were to create a hidden area with this value. It could Ript, but the issue may be re-used in any way to verify and return the form, it can not be sure how it ....
Read more

javascript - Enable/Disable form elements and changing the values of button at a time? -

requirement: text is a button with "disabled" when the page opens, then I want to disable it when the user clicks on button , I want to enable my form field and at the same time I want to change the value of my button to "enabled." I have an example of how the button's value, but how can I enable / disable it at the same time? & lt; H: form & gt; Please press this button & lt; H: command button id = "cb1" value = "# {ActionBean.buttonText}" instant = "true" functionalist = "# {ActionBean.processMyAction}" /> & Lt; / H: form & gt; My Bean class looks like this: / * action listener method * / public zeroes process my action (verb phenomenon) {disable =! Disable; System.out.println ("disable:" + disabled); If (buttonText.equals ("disable")) {buttonText = "enable"; System.out.println ("Button Type:" + Button); } Else {buttonText = "disable...
Read more