Greetings dear forum members, .. Regarding this issue, I have obtained two solutions kindly provided by jolivanes and Artik in a cross post from another forum that can be reviewed at the following link:
Solutions to the issue
I hope it can also be of use to you if you are also looking for...
Yes indeed, ... thank you, what you tell me ... I saw that I was not going to have a suggestion or possibility of a solution, I understand that sometimes we are very busy, but I wanted to solve why I had to submit a report with the image ...
A thousand apologies and just enter to indicate that I...
Greetings I would like to know if I need to provide more explanation of the subject or perhaps it is not possible to upload the image to userform in this case. I would like to know, because I understand that the image changes its name every time it is generated
Greetings forum members.
With a macro a QR image is created, ... I would like to be able to upload it to userform1
I have tried various things, but cannot.
How could I achieve this?
Thank you in advance for your collaboration
Thank you Chihiro
In a userform we can have control of all the sheets.
mmm! But, for your answer, .. I suppose that the search or filtering with combobox, can not be done in userform ...
Thanks for your reply.
Actually, I do not know how to apply the vba to search by filtering vba by selecting in combobox what I want to filter.
As you will see the CbxAño searches and finds, (only this), ... but you are right is not very flexible. Now, what I filtered would like to see it in the...
Dear forum friends, I can not find a way to make a search using a single combobox or several comboboxes. Surely you have to use the "and" or "or" operators and show me in the listbox what corresponds based on what is shown in Sheet 2 (Resum)
I appreciate your kind collaboration
upload the file...
Dear Master Hu, your guidance has led to certain issues and has become the problem in more complexity. But it seems that it is already taking more realistic form. and I thank you for that.
Taking into account date of beginning and date and days of delay that is estimated will end date of the...
Thanks Maestri Hui, I think that the values must correspond and be automatic, if I put the 1 in weight the percentage of management increases, for this, .. for E5 to E11, =IF(C5=1;0.1;IF(C5=2;0.4;IF(C5=3;0.6;IF(C5=4;0.8;IF(C5=5;0.9;"")))))
although these two actually come to be the same for the...
Thank you Master Hui, the average, I had not seen, excellent! It is wrong to try to calculate the percentage of percentages.
But in the matter of applying weight, I lost myself there, in the calculations you have made.
Anyway, the weight would also put it in a subjective way when I put from 1...
Dear forum friends, I would like you to help me, in a formula to calculate the percentage of items that are in percentages. I expect the result to be in cell E4.
Take into account that when each cell below E4 is 100% fulfilled, the value of E4 will increase until reaching 100% compliance...
Great, although it leaves me with no questions because I do not know if it is associated to a pre-established code, or it is generated randomly. If it is one established as ASCII, some good expert will decipher it.
That is why he proposed his own alphabet.
I would like to do a test:
Can you...
Dear Marc L,
The lightness sometimes brings problems! I apologize..
And that happens to me because I do not know how to handle functions from the userforms
I have now reviewed that I am on the desktop with my own PC, I have seen that you use functions and this mecrum and decode with...
Master Hui, this result very goo!!
Case Is = Chr(32)
newletraMay = newletraMay + "0"
to include space.
only, is error decrypt gtext when I use LEER button
Greetings Master Hui, I understood, .. the solution was that I join all the codes of the select case, .. so I did and it turned out very well.
What I have left is to incorporate the space bar and insert a zero "0" in the sheet and then use the READ button
sorry I was slow to understand
Dear teacher Hui, yes! Likewise, it's just how I want it to work.
But as I see what you have written is "ello handoo" as the capital letter H and C has not come out
How is it possible to write Hello Chandoo, capital letters and minuscule?
I also can not decipher when I click on the READ...
Dear friends of the forum, with the aim of generating a userform to encrypt and decrypt text I would like to achieve that what is written in textbox1 can enter in cell B2.
Likewise can show in the textbox1 what is contained in cell B2
The macro is made with characters selected in a personal way...
Thanks GCExcel, it works very well, just as I wanted, however I thought that the code that I put
sub separar()
g = Hoja1.Range("B" & Rows.Count).End(xlUp).Row
'Separar los numeros en cada celda
código = Hoja1.Range("BA" & g - 1)
For y = 1 To Len(código)
Hoja1.Cells(g, y + 3) =...
Thanks for answering, I really just want the letters to be located separating every 4, that is, in the fifth position there will be an empty cell in the direction of the cell with yellow filling.
It is a test result sheet for students.
Now to exploit the green colors, it really is: number of...
Dear friends, what can I miss to get every 4 cells to skip a cell and continue separating the letters of the contents of a cell?
so that it is the same as shown in row 10 from cell 4
I upload the file so you can see it
I appreciate your support in advance
Excelent!!
Is what I wanted, it starts inclusive when there is no number, and of course, the conditional was necessary
Thank you for your contribution has served me and is more simplified codification