HTML i need help guys please

Jack in the UK · Jun 3, 2002

I posted this, thought was good post, but left large spaces between lines>>>

I wrote the code, im learning = this is as is,?? Any ideas??

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>The other way you might wish to UDF is via VBA</title>
<style>

</style>
</head>

<body>

The other way you might
wish to UDF is via VBA, this is a script I wrote to add a A in from of any cell
value less than 10000 i.e. 9999 to 0 will be A999 or A0001
The function you need is
related to the range but try


=JackintheUK_ConvA(A1)


Put this in VBA by:
In Excel as normal = Press
together the Alt+F11 keys and let go, you will see a new kind of program appear
this is the Visual Basic for Application Editor (VBE)
There will be little in
the Project = Project VBA window pane.
Look for the name of your
sheets, (will say VBA Project (your workbooks name) helps of only on book open
till you get used to its, it like windows explorer you soon see it, but name as
normal
Select this WkBk *VBA
Project (your workbooks name)* and there will be nothing in it.
Just below you see a name
bit called Microsoft Excel Objects
Now right click it
on the name part. 
A pop up appears.
Choose
INSERT

And select module, 


A bit of flick and
clicking and you see a new line has appeared, called

MODULES / MODULE 1

Click on this and paste
in my code I have provided.

Don't forget in cells

A1 type 666 


A2 type 10004

In B1 type = 


=JackintheUK_ConvA(A1) and drag down one.

The results will
be A0666 and 10004

Function JackintheUK_ConvA(MyRange As Range) As String

Application.Volatile

MyFormat = ("A0000")

If MyRange < 10000 Then

JackintheUK_ConvA = Format(MyRange.Value, MyFormat)

Else

JackintheUK_ConvA = MyRange.Value

End If

Calculate

End Function

Formula needed on Jacks UDF

=JackintheUK_ConvA(A1)

</body>

</html>

Von Pookie · Jun 3, 2002

Hi Jack!

It looks as if using copy/paste from FrontPage has some extra code in there you don't need to worry about for just posting on the board

For example, if you want to change the font, you can just type [font face="Tahoma"]Jack[/font] (just change all of the brackets to<>). This will be posted as:Jack

Also, to make it change size and color, just add to the font tags as [font face="Tahoma" color="#0000FF" size="3"]Jack[/font] to getJack

The extra stuff you pasted in there such as

HTML:

, [body], etc. are things only needed for making an entire separate page (right-click on this or any page and choose "View Source". They all start with that.)

Did this help any? Let me know if you have any trouble with it!

Kristy

_________________<font color=red>~*</font><font color=blue>Kristy</font><font color=red>*~</font>

"Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam."

[img]http://community.sierra.com/WebX?31@@d21b3@2[/img]</img>
[SIZE=2][COLOR=gray]This message was edited by  Von Pookie on 2002-06-03 19:15 [/COLOR][/SIZE]

Colo · Jun 3, 2002

Hi Jack,
I think "php proglam" of this site is add
Automatically.
So, when we want to write HTML into here, we have to write with in 1 rows.

For example:
In case


This is a
Test


to

This is a Test 

HTH

Jack in the UK · Jun 4, 2002

Cheers guys, me and HTML , well i don't very well, not that i Excel well either.

I am developing to move out of the confined constraints of my poor posts, with the acquisition of a keen eye and heavy software applications, this is on my SCRIPT WRITER.

The desired result is: to make my post as nice and accurate as possible, not Jack_O_Nence and this was part of it, i have a converter, i guess FrontPage would do the same, which i use as well, just my hate of WORD that's all, I also use am extreamly powerful peice of software which cost me a million bar a few cents to develop my posts, thus hope rich wording and complex made simple, Jack hopes.

Adding colour draws the eye to emphasis issues?

OK Kristy, I'm sure we will chat soon over this and ill take you advice without question.

Colo - You say board issues, but why that code is on the money or ill hang the software company, its dead on, i know that, the php program does not like this. So would i be best if that the issue to get php friendly version of FrontPage or similar, more expense but worth it.

Von Pookie · Jun 4, 2002

...i have a converter, i guess FrontPage would do the same, which i use as well, just my hate of WORD that's all...

I thought you were using FrontPage. If I go to your post above and click on the "edit post" button, I can see the code you posted, which says FrontPage in it.

Adding colour draws the eye to emphasis issues?

It can, but it can also be overdone

Jack in the UK · Jun 4, 2002

Thinking your right Kristy im wrong and have not meaning mislead you, well at least tied to.

I use a script editor to make the TEXT not Jack_O_Nence and them YES correct i have wacked into FTP and coloured and copy and paste.. Opps!

My fault and telling porkie pies there, well not really did not think this would matter, WRONG i am.

OK so FTP over cooks it?

I was looking for ease, of use? Not so. Should have known but no try no learn.

My script writter works fine with also a wordeness program that look at GRAMMER Jack seem to not have any of that, this is the extra kit, then to FTP and make pretty and over to MrExcel?? Nope Nope wont like that one.

I have a HTML help book Microsoft press ill lend myself tommorow and work from there.

Kristy - yup looked at the source >>>>> Yikes! Im not going in theres wow!

BTW this i have made in Jack_O_Nence so you can see the difference, and draw some comoparison to my other *quality* post.

YES i have read at least twice and editted and then post.. thisis the Jack_O_Nence we love but best when hes hidden.

HTML i need help guys please

Jack in the UK

Well-known Member

Von Pookie

MrExcel MVP

Colo

MrExcel MVP,

Jack in the UK

Well-known Member

Von Pookie

MrExcel MVP

Jack in the UK

Well-known Member

Forum statistics

Share this page

HTML i need help guys please

Jack in the UK

Well-known Member

Von Pookie

MrExcel MVP

Colo

MrExcel MVP,

Jack in the UK

Well-known Member

Von Pookie

MrExcel MVP

Jack in the UK

Well-known Member

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock