Posts by IanPeter

Re: use message box to report cell values

THank you. Works brilliantly. If one just wanted to change the triglyceride value color to red, how would that be coded?

Re: use message box to report cell values

Another question. Is it possible to colour values, say over 20, retrieved from column J using the user form. Simply to highlight values that are 'off scale' in terms of reasonableness
Thank you

Re: use message box to report cell values

Wow,wow and wow!! Thank you so much for all of the help. I will be able to get on with the larger project now. The problem there is getting the data from the pathology system which has fairly few facilities to do what I am trying to achieve.

Re: use message box to report cell values

I am afraid that there was no command button. I am opening it on a Mac using Excel 2011 - is that a problem? I have re-attached the file just in case

Re: use message box to report cell values

OK. Me being stupid again. I thought that when I run the macro test, the results would appear in the form that you had so kindly designed and scripted for me ( very grateful). However the results appear in the message box. I have in the module the sub test and the form carries the script that you wrote. How do I get the routine to bring up the results in the form? Are the scripts in the correct place?

Re: use message box to report cell values

According to the thread dummy_trial3 has been downloaded as an attachment.

Re: use message box to report cell values

Please!

Re: use message box to report cell values

At the moment I have the original search macro as module1, I also have code associated with the user form. If I run the macro , I get the message box: I cannot get the user form report unless I go into VBA, select the user form and use F5 - it then runs perfectly. I guess that I need another module to call the form??

Re: use message box to report cell values

How do I get the results to appear in the form rather than the message box?

Re: use message box to report cell values

A very basic question. How do I get the results to appear in the userform rather than the message box when I run the macro?

Re: use message box to report cell values

Thank you for the information on the combo box. The thread helped me to solve that issue

Re: use message box to report cell values

I would like to highlight certain results on the sheet

Re: use message box to report cell values

Too quick off the mark, I'm afraid. When I run the macro, the results appears in the message box, which I assumed was the form. How does one get the results presented in the form rather than the message box. I guess formatting of the results is from the form controls. Would it be possible to highlight or colour the abnormal results? Not particularly important for this set of results, but if I were to expand the application ultimately to screening 100 x 2000 rows of data, it would be useful to have highlighted the results that brought the record up in the first place. In the latter case I shall probably bring the application back to bringing up single patients results per form rather than a list.
Many thanks for all of your help. It is much appreciated

Re: use message box to report cell values

Thanks for this. How does one format the font, colour etc ? Would it be possible to have headings and the data beneath?
So Name Requested by Telephone Chol Trig Date and then the data below in a sort of table format? Please tell me to stop asking if this is really stuff I need to discover for myself. One more question, in trying to understand the user form, I followed a tutorial on the internet. The only part that I cannot figure out is the combos range using Excel 2011 for MAc. There is no field that I can discover to link the range of possibilities to the drop-down

Re: use message box to report cell values

Sorry about this. I really don't have a clue how to get this done. I have modified the msg in the form 'macs'. I guess what would be quite neat is to have headings for patient, request, phone and the two results plus date and somehow get each patient's results under those headings on the form. I get them in the format similar to the message box. How would I for example change the font colour of the headings to distinguish them from the data. I am sure that you would have a much clever idea on the display. I am quite lost despite reading!
Many thanks

Re: use message box to report cell values

Thank you. I shall go through this carefully and try to modify it as I gain expertise.
Cheers

Re: use message box to report cell values

Please forgive my ignorance. How do I go about doing that, please. I have very limited experience with Excel and VBA, I'm afraid. Also is there a good book to get the knowledge that you could recommend?

Re: use message box to report cell values

Is there a way to create something similar to a message box, but that one can format?

Re: Maximising use of AutoFilter

Problem solved! I deleted all modules from the macros that I use for this spreadsheet which is initially received as a csv file. I then reloaded the module for identifying and reporting the results and it now works perfectly. Iguess that I must have had more than one module that conflicted.
A last question on this topic. Is it possible to transfer the results to appear in a formatted way , similar to the message box in appearance, but with formatted text ?

Re: Maximising use of AutoFilter

Hi again. Something weird happens when I use the macro on the "real" thing: although the real data have exactly the same format as the dummytrial and the macro works perfectly with the dummyfile even when I copy the "real" data to it.
When I use the macro as it is written, I get the message Compile error: Expected End Sub. When I add End Sub below the last End If, I get a compile error: Only comments may appear after End Sub, End Function, or End Property.
What have I done or what do I need to do? THanks