excel vba - Adding Code to a Command Button that was dynamically added to a frame in a user code -


This is a Vibe question: I got this question: "Adding control over a frame in Excel User with VBA" and my user It was used to add commandbutan to the frame in the form. Since I have added four commandbots, I participated in a loop code and with 

  ... .name = "command button" & amp; X

Give each command button your name; I included my code macro for every CommandButton (because I gave them names I know that each is CB name) but when I click on the button Click, nothing happens.

Or, if someone could explain to me how to use the code to control a form in a frame, I can solve my problem in a different way.

thanks,

Michael

It seems that The events are controlled only for the object variables which were declared when the VBA program has been compiled (i.e. in design time.) When you create objects in dynamic form (ie in run-time) then you have the right object variable which To be declared, the references to those items will be handed out.

According to your example, in the module which is related to your UserForm , you will need: 

  btn1 People WithEvents MSForms.CommandButton People WithEvents as btn2 MSForms.CommandButton Public WithEvents as MSForms.CommandButton P. btn3 ublic withEvents btn4 MSForms.CommandButton as

( MSForms variable Type prefix might not be extremely necessary)

Then with your in control you can get one of the variables which ends up being quite dirty Everyone Iyntrn statement to the need to allocate

better solutions :.

  • Create maximum number of possible buttons at design time and toggle the visible property to show the right people
  • If the function of each button Use some property of the CommandButton object (such as caption property, tag ) to determine if it can be set to run-time. Code> property) and then the event handler for that button, depending on the property
  • By changing the UI and clicking the list box or combo box

Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more