So I have a table and some of the formulas yield a number that is less than the number (<1), I want this number to be reported over to my textbox but the less than sign has to be dim as string and the 1 has to be dim as long. Is there a way around having to separate these out or can I create a rule that will report the number <1?
Why do the '<' and '1' need to be dimmed as anything?
Can't you just put the value from the cell directly into the textbox?
Or if you must use a variable use a string for the whole thing.
Last edited by Norie; 07-10-2017 at 11:15 AM.
If posting code please use code tags, see here.
The numbers change based on different values so I am dimming the range not necessarily the <1, but the properties are sometimes just long so it returns a mismatch if the value happens to add the <. These are percentiles, so for instance most of the time the number is just a number PR= 50, but when a very low score is obtained then the percentile drops to <1.
I'm not following, I though you wanted to 'report' a value to a texbox which I assumed meant populating a textbox with a value.
Is there something else happening?
I am new at this...I think I was over complicating my code due to inexperience, my apology.
Last edited by JennaM; 07-10-2017 at 12:36 PM.
Where do you want to insert the contents of the cell?
If you wanted to insert the contents of a cell in a textbox you could use this,
and to put the value of one cell in another.
Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you, this works, I appreciate your help! I am having fun learning VBA but clearly I have much to learn!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks