Save data from UserForm textbox to a cell

I have a user form that pops up when someone enters rejected in a cell in row AA. I need the form to unload into the corresponding cell in column AE. Unsure of how to get this done.

Please Login or Register  to view this content.

Not sure of how to get this done.

We can't figure out what you want to do by looking at code that doesn't do what you want to do. This code puts data from a cell into the form, in a control of some kind called REJECT. What do you want to do that is different from that?

We also can't help at all with no information about your form. What controls on the form are relevant to your problem?

I suggest you attach your Excel file so we can see the big picture.

Also I suggest you not use the term "unload" because that means something very specific when you are talking about userforms, and it's different than what you mean here. I think you want to "Save data from user form to a cell".

You have a couple of different problems here.

First of all the code you showed above does not exist in this file.

The user form collects a reason for rejection if the value in AA is "Rejected". However, the data validation in column AA does not allow the user to enter "Rejected", only "Approved". Second, AA is for Level 1, and there is no column for "Level 1 Reason for Rejection". AC is "Level 1 Approver", and AE is "Level 2 Approval Date". AG is "Level 2 Reason for Rejection", but there isn't one for Level 1.

I have added a Submit button to the form to explicitly close it. The user can close it with the X but it is not intuitive that is what they are supposed to do. There is a button there but it's just a graphic, and there is no code associated with it so nothing will happen when you click it. No idea what you had in mind there.

I have corrected your code in the file but you still need to sort out exactly which column you want the result to go in.

Last, I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors.

Please Login or Register  to view this content.