Oopps, no I did not know that!!!! Sorry, I was misinterpreatin g your e-mail!!! That indeed works!!! THANKS! I will work further on my procedure. Great this progress!
Thanks again.
All the best,
Victor...
geniet
Last Activity: Feb 6 '08, 08:35 PM
Joined: Aug 10 '06
Location:
-
I have my Add-in already a few years, so that is done;-) I can refer to XLA (user defined) functions in the cells of my spreadsheet. VB module function-calls (part of the spreadsheet) in the button sub work oke. I am not able to do XLA function call from button sub or modules part of the spreadsheet.
It looks to be about visibility of xla function-calls from button subs or modules (as said; cells with xla function calls work).
...Leave a comment:
-
Hello Sammy,
I am able to make a sub that starts when pressing a button in the worksheet.
...Code:Sub Button2_Click() sunlow = Range("sunlow") viscous = Range("Viscous") Timehour = Range("Timehour") ABLday = Range("ABLday") entrainperc = Range("CBLentrainperc") ABLdeltanight = Range("ABLdeltanight")Leave a comment:
-
I was indeed, but also I was working on getting the theory behind my refraction program better (getting the temp/height profile;-). Sorry.
I am now able to start to incorporate your ideas. So it might be I have a question;-)
I saw when doing multiple times your buttom click, I get an additonal row...
But I will now implement something myself first (using your idea).
THANKS.
All the best,
...Leave a comment:
-
This is really helping Sam. I think I can use this method of yours for my work (I also never used froms, etc., so this also is great to learn!).
Thanks.
All the best,
Victor...Leave a comment:
-
I tried to use a sub called from a user defined function, but that does not work. See one of my earlier e-mails above.
That is not what I want, I think. See below, I only want things put in these cells once... (say as initialization of a spreadsheet table/range)
Oke the gorry details (it is related to refraction calculations using a height-temperature profile: http://www.iol.ie/~geniet/eng/tropospherelayers.htm ). I have...Leave a comment:
-
Indeed this works, I use that method for all my user defined functions. Just to be sure, I don't want to have the resulting value in the cell where the function is defined, I want a particular cell in my spreadsheet to get the value 23.
This does not work as an user defined functions, subroutines are not allowed, only functions. If I change the Sub in Function, it is stillnot working.
I put breakpoints in the Visual...Leave a comment:
-
I want to put a calculated value into a certain cell of my worksheet. Of cause the value is calculated using some otherfunction, but in essence it is this simple;-)
So "put in cell C1 the value 23" and this within a function made in Tools macro VisualBasic Editor.
Hope you can help.
All the best,
Victor...Leave a comment:
-
I am making user defined functions under the 'Tools' -> Macro -> 'Visual Basic editor' and that VB editor is version 6. So perhaps I was given wrong infromation...
The use defined functions are in Modules -> Module1
I have it on Low.
I can record a macro indeed. It sets a cell active and then put the value in the active cell.
...Code:Sub testing2() ' ' testing2 Macro ' Macro recorded
Leave a comment:
-
I had to change it to a function (instead of sub) otherwise I can't use it in a Excel cell.
But still same results. No 'Hello' in Cell(1,3) and error message #VALUE! in the cell with the '=test2()' function.Code:Public Function test2() Cells(1, 3).Value = "hello" End Function
All the best,
Victor...Leave a comment:
-
Don't understand that. I just use Excel. Have a module (called Module1) where I have a function that should set a cell.
Public Function test()
Range("C1").Val ue = "hello"
End Function
Nothing gets in cell C1 and the test() results in #VALUE!
All the best,
Victor...Leave a comment:
-
Same effect. My VB program is aborted. No errors mentioned, etc.; so don't know why and what goes wrong... Almost sounds like I need to re install excel.
Still desperate for a solution...
All the best,
Victor...Leave a comment:
-
Does not work for me... Sorry. I hope I do something else wrong...
All the best,
Victor...Leave a comment:
-
setting Excel cell.value through Visual BASIC
Hello all of you,
I have some problem in setting cells values (or fromat or...) in my Excel spreadsheet using a VB statement like within my Module:
Range("C1").Val ue = 20
I have this in a function. If I am in debug mode and have a breakpoint at this line, I can see when hovering my mouse over "Range("C1").Va lue" the actual value in that cell (in my case 30), but when I want to step... -
Hello,
I am also relatively 'young' in VB, but I think the # in a constant decalaration means that one wants it to be double precision. This is from the help file of Visual Basic:
The number sign (#) type-declaration character represents the Double in Visual Basic.
Hope this helps.
All the best,
VictorLeave a comment:
-
add jpg app3 marker to jpg/jpeg file
Hello all of you,
I am looking for a program where I can add and edit the APP3 marker according to jps format (if needed Python/PIL can be used).
The setup of the APP3 marker comes from this definition:
http://www.vrex.com/developer/sterdesc.pdf
In some way I want to put in the APP3 marker the following:
"_JPSJPS_<bh:00 ><bh:04><bh:00> <bh:04><bh:02>< bh:01><bh:00><b h:0D>...
No activity results to display
Leave a comment: