The Complete MBA Coursework Bundle 1-3 : Short introduction to MS Excel & Tips you must know about Word & Automate the boring tasks using VBA by Ibnalkadi Hicham & Mohamed

Author:Ibnalkadi, Hicham & Mohamed [Ibnalkadi, Hicham and Mohamed]
Language: eng
Format: epub
Published: 2021-04-29T16:00:00+00:00

Macro Code

Below is the code for the macro.

'Splits the contents of a cell into many cells or joins selected

'cells into one single cell given the user selection.

Public Sub SplitJoinTexts()

'Macro's form

Dim f As New FormSplitJoinTexts

'Display form where all the actions are taken

f.Show

End Sub

Below is an overview of the macro form (FormSplitJoinTexts) , each picture represents one of the tabs (Split and Join).

Below is an overview of the macro form code (FormSplitJoinTexts) .

Option Explicit

'------------------------------------------------------

' INTERNAL ENUMS

'------------------------------------------------------

'Define split direction

Enum SplitDirection

splitDown = 0

splitUp = 1

splitLeft = 2

splitRight = 3

End Enum

'------------------------------------------------------

' INTERNAL VARIABLES

'------------------------------------------------------

'Split action source range - contains data to be split

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.