| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 1807 online users.
» 0 Member(s) | 1805 Guest(s)
Bing, Yandex
|
| Latest Threads |
SELECT statement with MS ...
Forum: MS Access SQL Tutorials
Last Post: Qomplainerz
07-27-2023, 03:35 PM
» Replies: 0
» Views: 1,076
|
SELECT statement with the...
Forum: MS Access SQL Tutorials
Last Post: Qomplainerz
07-27-2023, 03:31 PM
» Replies: 0
» Views: 528
|
Creating hyperlinks in HT...
Forum: HTML5 Tutorials
Last Post: Qomplainerz
07-27-2023, 01:23 PM
» Replies: 0
» Views: 822
|
What's new in HTML5?
Forum: HTML5 Tutorials
Last Post: Qomplainerz
07-27-2023, 12:48 PM
» Replies: 0
» Views: 545
|
What is HTML5?
Forum: HTML5 Tutorials
Last Post: Qomplainerz
07-27-2023, 12:43 PM
» Replies: 0
» Views: 513
|
Neck isometric exercises
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:44 AM
» Replies: 0
» Views: 808
|
Shoulder shrug
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:43 AM
» Replies: 0
» Views: 463
|
Neck retraction
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:43 AM
» Replies: 0
» Views: 431
|
Neck flexion and extensio...
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:42 AM
» Replies: 0
» Views: 500
|
Neck rotation
Forum: Exercises
Last Post: Qomplainerz
07-27-2023, 11:42 AM
» Replies: 0
» Views: 473
|
|
|
| Datatypes in VBA |
|
Posted by: Qomplainerz - 07-26-2023, 08:17 PM - Forum: Excel VBA Tutorials
- No Replies
|
 |
Datatypes define the type of data a variable can hold. VBA supports various datatypes, including:
6.1. Integer:
Used to store whole numbers between -32,768 to 32,767.
6.2. Long:
Used to store larger whole numbers between -2,147,483,648 to 2,147,483,647.
6.3. Single:
Used to store single-precision floating-point numbers with decimals.
6.4. Double:
Used to store double-precision floating-point numbers with decimals.
6.5. Boolean:
Used to store True or False values.
6.6. String:
Used to store text or alphanumeric data.
6.7. Date:
Used to store date and time values.
|
|
|
| Variables in VBA |
|
Posted by: Qomplainerz - 07-26-2023, 08:13 PM - Forum: Excel VBA Tutorials
- No Replies
|
|
Description:
Variables are used to store and manipulate data in VBA.
Declare variables using the Dim statement.
Example:
Sub ExampleVariables()
Dim myName As String
myName = "John Doe"
MsgBox "Hello, " & myName & "!"
End Sub
|
|
|
|
| Subroutines in VBA |
|
Posted by: Qomplainerz - 07-26-2023, 08:11 PM - Forum: Excel VBA Tutorials
- No Replies
|
|
Description:
Subroutines (Subs) are blocks of code used to perform specific actions or tasks.
They don't return any value.
You call a subroutine by its name, and it executes the code within it.
Example:
Sub GreetUser()
MsgBox "Hello! Welcome to Excel VBA."
End Sub
|
|
|
|
| Comments in VBA |
|
Posted by: Qomplainerz - 07-26-2023, 08:08 PM - Forum: Excel VBA Tutorials
- No Replies
|
|
Description:
Comments are notes added within the VBA code to explain what the code does. They are preceded by an apostrophe ('). Comments are essential for documenting your code and making it easier for others (and yourself) to understand its purpose.
Example:
Sub ExampleSub()
'This is a comment explaining the purpose of this subroutine
MsgBox "Hello, world!"
End Sub
|
|
|
|
| Macro recording |
|
Posted by: Qomplainerz - 07-26-2023, 08:07 PM - Forum: Excel VBA Tutorials
- No Replies
|
|
Excel allows you to record macros, which automatically generate VBA code based on your actions. This is useful for automating repetitive tasks. To record a macro, go to the "View" tab in Excel, click on "Macros," and then "Record Macro." Perform the actions you want to automate, stop recording, and save the macro. However, recorded macros may not always be efficient and may require manual editing.
|
|
|
|
| The VBA Editor |
|
Posted by: Qomplainerz - 07-26-2023, 08:06 PM - Forum: Excel VBA Tutorials
- No Replies
|
|
The VBA Editor is where you write, edit, and manage VBA code in Excel. To access the VBA Editor, press ALT + F11. It consists of the Project Explorer (to view all open workbooks and modules), the Code Window (to write and view VBA code), and the Immediate Window (to run immediate commands).
|
|
|
|
| CSS Grid Masonry Layout |
|
Posted by: Qomplainerz - 07-26-2023, 07:54 PM - Forum: CSS3 Tutorials
- No Replies
|
|
Description:
CSS Grid can be used to create a masonry layout, where items are arranged in columns with varying heights to create an asymmetrical grid.
Example:
<!DOCTYPE html>
<html>
<head>
<title>CSS Grid Masonry Layout Example</title>
<style>
.masonry-container {
display: grid;
grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
grid-gap: 10px;
}
.masonry-item {
background-color: lightblue;
padding: 10px;
}
.item1 {
grid-row-end: span 2; /* This item will span 2 rows */
}
.item3 {
grid-row-end: span 3; /* This item will span 3 rows */
}
</style>
</head>
<body>
<div class="masonry-container">
<div class="masonry-item item1">1<br>First item</div>
<div class="masonry-item">2<br>Second item</div>
<div class="masonry-item item3">3<br>Third item</div>
<div class="masonry-item">4<br>Fourth item</div>
<div class="masonry-item">5<br>Fifth item</div>
<!-- Add more items here -->
</div>
</body>
</html>
Explanation:
In this example, the .masonry-container creates a masonry layout using CSS Grid. The grid-template-columns property with repeat(auto-fit, minmax(200px, 1fr)) creates flexible columns that adjust according to the available space, with a minimum of 200px and a maximum of 1fr (equal share of the available space). The .masonry-item divs have varying heights and are arranged in columns, creating a masonry-style layout.
These additional examples showcase more advanced and lesser-known CSS3 features that can be applied creatively to enhance your web designs. As with any new feature, it's essential to check for browser support and consider fallbacks for older browsers if necessary. CSS3 continues to evolve, so keep exploring and experimenting to create cutting-edge web designs.
|
|
|
|
| CSS Custom Scrollbar Styles (Webkit and Firefox) |
|
Posted by: Qomplainerz - 07-26-2023, 07:52 PM - Forum: CSS3 Tutorials
- No Replies
|
|
Description:
You can customize scrollbar styles for WebKit-based browsers and Firefox using vendor-specific pseudo-elements and properties.
Example:
<!DOCTYPE html>
<html>
<head>
<title>CSS Custom Scrollbar Styles Example</title>
<style>
/* WebKit (Chrome, Safari) Scrollbar Styles */
::-webkit-scrollbar {
width: 10px;
}
::-webkit-scrollbar-track {
background-color: #f1f1f1;
}
::-webkit-scrollbar-thumb {
background-color: #888;
}
/* Firefox Scrollbar Styles */
/* Note: The scrollbar styles for Firefox require Gecko engine version 64 or higher */
scrollbar-width: thin; /* auto or thin */
scrollbar-color: #f1f1f1 #888; /* track color, thumb color */
</style>
</head>
<body>
<div style="height: 300px; overflow-y: auto;">
<!-- Add long content to enable scrollbar -->
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit...</p>
</div>
</body>
</html>
Explanation:
In this example, we customize scrollbar styles for both WebKit-based browsers (using ::-webkit-scrollbar pseudo-elements) and Firefox (using non-standard CSS properties scrollbar-width and scrollbar-color). The ::-webkit-scrollbar styles for WebKit browsers are similar to the earlier scrollbar styling example, while the scrollbar-width and scrollbar-color properties for Firefox allow you to set the width and colors of the scrollbar.
|
|
|
|
| CSS Object Fit and Object Position |
|
Posted by: Qomplainerz - 07-26-2023, 07:50 PM - Forum: CSS3 Tutorials
- No Replies
|
|
Description:
The object-fit property allows you to control how an image or video should be resized within its container, and object-position lets you specify where the image should be positioned.
Example:
<!DOCTYPE html>
<html>
<head>
<title>CSS Object Fit and Object Position Example</title>
<style>
.image-container {
width: 300px;
height: 200px;
border: 1px solid black;
overflow: hidden;
}
.image {
width: 100%;
height: 100%;
object-fit: cover; /* Other values: contain, fill, etc. */
object-position: right bottom;
}
</style>
</head>
<body>
<div class="image-container">
<img class="image" src="image.jpg" alt="Image">
</div>
</body>
</html>
Explanation:
In this example, the .image-container div has a fixed width and height, and overflow: hidden is applied to hide any overflow from the image. The .image image inside the container is set to width: 100% and height: 100%, making it fill the container. The object-fit: cover property resizes the image to cover the entire container while maintaining its aspect ratio. The object-position: right bottom positions the image to the bottom-right corner of the container.
|
|
|
|
| CSS Box Decoration Break |
|
Posted by: Qomplainerz - 07-26-2023, 07:49 PM - Forum: CSS3 Tutorials
- No Replies
|
|
Description:
The box-decoration-break property allows you to control how backgrounds, borders, and box shadows behave when an element is broken across multiple lines.
Example:
<!DOCTYPE html>
<html>
<head>
<title>CSS Box Decoration Break Example</title>
<style>
.decorated-text {
background-color: lightblue;
padding: 10px;
border: 2px solid red;
box-shadow: 5px 5px 5px grey;
box-decoration-break: clone;
/* OR use 'slice' value for different effect */
/* box-decoration-break: slice; */
}
</style>
</head>
<body>
<p class="decorated-text">This is a long text that wraps across multiple lines and the box decoration remains consistent.</p>
</body>
</html>
Explanation:
In this example, the .decorated-text paragraph has a background color, padding, border, and box shadow applied to it. By default, when text wraps across multiple lines, the box decorations are repeated for each line. The box-decoration-break: clone property ensures that the box decorations remain consistent even when the element breaks across lines.
|
|
|
|
|
