Solved

Input information on K column using userform.

Posted on 2016-10-18
15
23 Views
Last Modified: 2016-10-18
Good afternoon Experts Exchange community and users wanted to see if it is possible to have this userform to work in this way. Thanks for your time and help.

1. Input information using userform
      a. Click on the row that you want to input information.
      b. On the given # put in number
      c. Choose the color that the number will be displaying on.
       d. Click on Enable so that it may be active.
      e. Have information generated/input once you click close button.

Pictures and file will be provided on this question.  Please feel free to ask any question to clear out any inconvenience.

userform-on-k-column-results.png
userform-on-k-column-results-2.png28975135.xlsm
0
Comment
Question by:Omar Hernandez
  • 8
  • 7
15 Comments
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
The picture you show, while similar, is not what I see when I open the "Order" form named NumberArrange.

I also what to say that while it is of course your workbook, IMO you have way too many colors going on.
0
 

Author Comment

by:Omar Hernandez
Comment Utility
I apologize, Forgot to updated. Here you go Martin and thanks for your fast response. Reason that it has four different colors is to meet a conclusive end goal.
28975135.xlsm
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
I was talking about the colors on the GENERAL sheet where you have at least 9 colors.

What should happen when CommandButton13 (ENABLE) is clicked?
What should happen when CommandButton14 (DISABLED) is clicked?
When you say "Have information generated/input once you click close button", what information do you want to show up in column K?
0
 

Author Comment

by:Omar Hernandez
Comment Utility
What should happen when CommandButton13 (ENABLE) is clicked?
---on the row selected column "K", Show the number i have input on the userform (located on letter B)

What should happen when CommandButton14 (DISABLED) is clicked?
---on the row selected column "K", Don't show the number input on the userform (located on letter B)

When you say "Have information generated/input once you click close button", what information do you want to show up in column K?
--- Yes remember that when i also click on the close button other information will be generated/input, will love to have the previous function work in addition with this new information that will be generated/updated as well.
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
When ENABLE is clicked do you want to immediately see the number appear in column K?
0
 

Author Comment

by:Omar Hernandez
Comment Utility
I would prefer to have it when i click on the "CLOSE" button. with also having previous updated information when updated working in conjunction with the new information to update.

But, would not mind if it is easier for you doing it the way you have mentioned.
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
I'll do it when the CLOSE button is clicked.

I'm sorry for all these questions but if the user wants to see the number does he have to click ENABLE before clicking CLOSE? And what happens if he clicks DISABLED before clicking CLOSE? Am I right in assuming that in that case you don't want the number to appear but you do want the rest of the existing code to run? If so wouldn't it be simpler to eliminate the ENABLED and DISABLED buttons and instead just put the "Given #" in column K if it's non-blank?

Anther question is how does column K become something like the "7  !  13"  in cell A29?
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Omar Hernandez
Comment Utility
Hey Martin Liss no problem at all, better have question so that you may understand it with ease and clearness as much as possible.

If the user wants to see the number does he have to click ENABLE before clicking CLOSE?
---Yes, if it is possible to have the option click to be highlighted will appreciated. so that the option picked will be shown.

what happens if you click DISABLED before clicking CLOSE?
---If i click on the DISABLED button before clicking CLOSE, what ever information that is in the userform it will not be shown on the selected row, column "K".

Am I right in assuming that you don't want the number to appear but you do want the rest of the existing code to run?
---Yes, if the recurrence box is disabled, have previous information that when button close is clicked generated. and if it is Enabled have Recurrence box information work in conjunction with previous updated information that generates only when close is clicked.

If so wouldn't it be simpler to eliminate the ENABLED and DISABLED buttons and instead just put the "Given #" in column K if it's non-blank?
--- Yes, but reason i have it vision this way, is because it has other function that will be dealt with with a new question.

Anther question is how does column K become something like the "7  !  13"  in cell A29?
---This also is to be answered in a new question. For more understanding on the userform you have two box where a number is input one is called "Countdown" and "Given #".

Given # = number of days it will have to recurrence let's say this is the " 7  !  7" created on Oct 18

Countdown box = is showing the actual day that has passed. Let's say after i have input the number on the given# being on oct 18, three day has passed and now on the countdown box we will see the following  4 ! 7

Countdown box      Given #

          4               !              7
0
 
LVL 45

Accepted Solution

by:
Martin Liss earned 500 total points
Comment Utility
Try this.
28977190.xlsm
0
 

Author Comment

by:Omar Hernandez
Comment Utility
does not show nothing when i

add a number on the given #
choose color
click enable
click close

Is there another way you have it, so that it may display on the file
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
The ENABLED button is now a toggle so if you click it it will change to DISABLED and nothing will show up. The default state is ENABLED so don't click it.
0
 

Author Comment

by:Omar Hernandez
Comment Utility
I see, for some reason when trying to make the number display in RED it display in blue.

Beside this it works great.
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
Change line 3 as shown

Private Sub CommandButton8_Click()
'******* 28977190 Start *******
Set mCB = CommandButton8
'******* 28977190 End *********
End Sub

Open in new window

0
 

Author Closing Comment

by:Omar Hernandez
Comment Utility
Works great, with a mind like yours visions will be possible. Thanks a mil Martin Liss.
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
You're welcome.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now