afterupdate

Hello, I have a userform with a bunch textboxes. I would like to format most of them as numbers with no decimals. The group of textboxes I would like formatted in this manner are consecutively numbered. I have the below code, which works, however, it is extremely cumbersome given the number...

Hi, i am curikus whether it is possible to set a macro for afterupdate action for created in runtime combobox? I get an error for not supporting such operation: ...'creation of cb on button click MyCB.afterupdate = "mymacro"

I have a class that groups several textboxes in a userform for event handling. Here is the class: Private WithEvents MyTextBox As MSForms.TextBoxPublic EnableEvents As Boolean Public Property Set Control(tb As MSForms.TextBox) Set MyTextBox = tb End Property Private Sub...

I have a textbox in a userform and would like to get the 'name' of the textbox upon the AfterUpdate event executes. At the moment I am using ActiveControl.Namebut as the focus has changed to the next control in the TabIndex, it returns the name of this control rather than the textbox that has...

I have a form in excel that includes a large number of controls. For many of the controls, there is an _AfterUpdate event that fires correctly when the user enters data. The _AfterUpdate code makes entries in one or more ranges in the associated spreadsheet (I am not using the ControlSource...

Hi Guru's I'm using vbProperCase in a sub AfterUpdate. However, the vbProperCase does not take into consideration last names that have a hyphen or apostrophe. So, I found a function to solve the issue, but I'm not sure how to implement it. Can someone please walk me through this? Much...

I am pretty new to VBA and have learned most of what I know on this site. So I figured if I had a question I couldn't find the answer to this would be the site to come to. I am trying to create a sheet that is a database of parts. I have created a user form that lets you fill in the different...

Hi, I'm having some trouble with a code I'm currently working on and I would really appreciate some help. What I'm trying to do is the following: I have a range (A1:A50), each cell populated by a string value. The vba code is looping through all the range cells and if a specific value is...